Be aware though that this option is only available on the
latest versions of excel.
In excel 97 userforms are always modal
-----Original Message-----
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
.