msgbox query
 

A modeless userform????

msgbox query
 

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

msgbox query
 

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

.