Hi Jon,

A modeless userform????


In VBA you can create userforms (Insert, userform).

Those forms can be shown modal (default) or modeless, which enables the
user to work in Excel whilst the userform is showing.


To show a Userform named Userform1 in modeless state, one uses:

Userform1.Show vbModeless

Omitting the vbModeless argument shows the form in modal state, so the
user cannot "click out of the form".

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com