form monitors users activity on sheet

  • Thread starter Thread starter okey
  • Start date Start date
O

okey

I have a huge ss and need to work with all of it. There are certain
cells in each long row that I'd like to see at all times.

I have a "viewer" connected to a hot keyed macro that does just that.
The form also allows editing of those cells.

Is is possible that the form can be made to follow me while I work on
the ss? If I move to row X, the form senses that and get the data
from that row. I could install some goto controls on the form, but I
rather the form follow my activities while I work on the ss.

And I want the form. It has tools that help display and edit complex
strings. Just moving the cells to a central area on the ss is not
enough.

Thank you.
 
You could try splitting the window, and having the form in one of the splits.
--
Cheers,
RyanR

--- pls click yes if I''ve helped you ---
Click to expand...

Got this from the programming branch:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal
Target As Range)
MsgBox "this is changing in cell"
End Sub

Just hook into the sheet's events and the form can follow anything you
do. Slick..
 
Back
Top