T
Troubled User
In the Worksheet_SelectionChange event I have some code that determines if
the cell you are on is a named range, if so, a UserForm is displayed in
non-modal mode showing some of the attributes of this field in another
systems, based on lists within this file that populate the UserForm when
activated. All of this works great, however, when the process is done (it
work immediately) the user (control) is in the UserForm, not on the active
workbook/activecell. I need to I have tried everything (including running
the code in different places such as on the form and at the end of the
SelectionChange):
- Thisworkbook.activate
- Activecell.activate
- Selecting the named range
None of these "re-activates" the worksheet rather than the User Form.
Any help is much appreciated.
the cell you are on is a named range, if so, a UserForm is displayed in
non-modal mode showing some of the attributes of this field in another
systems, based on lists within this file that populate the UserForm when
activated. All of this works great, however, when the process is done (it
work immediately) the user (control) is in the UserForm, not on the active
workbook/activecell. I need to I have tried everything (including running
the code in different places such as on the form and at the end of the
SelectionChange):
- Thisworkbook.activate
- Activecell.activate
- Selecting the named range
None of these "re-activates" the worksheet rather than the User Form.
Any help is much appreciated.