| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox query
A modeless userform????
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
| Msgbox query | Excel Programming | |||
Hybrid Mode
