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

Hi Jacob,

Go to http://www.bmsltd.co.uk/Excel/Default.htm and download the xls
file named 'FormFun.zip'. It should help you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Maybe look at the mouseover event of the userform.

--
Regards,
Tom Ogilvy

"jacob" wrote in message
...
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 informatio
any help appreciated