Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
form follows user's activity on sheet and updates itself
(repost - I think this one belongs here)
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 gets 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 what I want.. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
form follows user's activity on sheet and updates itself
Can you supply the code you are using now for the userform?okey;430289 Wrote: (repost - I think this one belongs here) 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 gets 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 what I want.. Thank you. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119536 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
form follows user's activity on sheet and updates itself
with the form modeless, you can navigate around the workbook
in the dorm, you can declare public subs that you can interface with from other VBA code and these subs (procedures) can populate the viewer so lets say in the form you have Sub SheetChanged(sh as worksheet) SelectionChanged sh.Selection End Sub Sub SelectionChanged(target as range) 'some code here End Sub now in the code page for ThisWorkbook you can trap sheet change and pass it to the form. Private Sub Workbook_SheetActivate(ByVal Sh As Object) frmViewer.SheetChaneg sh End Sub you can do a similar thing with selection changes, but using ThisWorkbook's event and not the individual sheets' events Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) With frmViewer .SheetChanged sh .SelectionChanged Target End With End Sub "okey" wrote in message ... (repost - I think this one belongs here) 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 gets 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 what I want.. Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
form follows user's activity on sheet and updates itself
Sub SheetChanged(sh as worksheet) * * SelectionChanged sh.Selection End Sub Sub SelectionChanged(target as range) 'some *code here End Sub Ahhh! A whole new world. Thanks. Exactly what I wanted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alert if the travel activity is after the work activity | Excel Worksheet Functions | |||
BLANK WORK ORDERS OR DAILY ACTIVITY SHEET TEMPLATES | Excel Discussion (Misc queries) | |||
Getting user's Date from a Form | Excel Programming | |||
How to autofill Excel form with User's Name (i.e., from Outlook) | Excel Programming | |||
How to autofill Excel form with User's Name (i.e., from Outlook) | Excel Programming |