J
jacob
I have a userform which would benefit from being run
modeless. When running it modeless I need to update
parameter lists in the userform, whenever the user wants
to use it again, to reflect changes in books, sheets etc.
Thought I could use the UserForm_Activate event for this,
but it will not fire.
Is there any event I could use for this? If not, how can
I know when the user starts to use the form again,
without her hitting any commandbuttons etc. on it, which
might misfire due to not updated information.
any help appreciated
modeless. When running it modeless I need to update
parameter lists in the userform, whenever the user wants
to use it again, to reflect changes in books, sheets etc.
Thought I could use the UserForm_Activate event for this,
but it will not fire.
Is there any event I could use for this? If not, how can
I know when the user starts to use the form again,
without her hitting any commandbuttons etc. on it, which
might misfire due to not updated information.
any help appreciated