| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use a worksheet while running a userform?
You can use Conditional Compilation to test if you are running in
VBA6, which is the version of VBA used in Excel 2000 and later. E.g., #If VBA6 Then Userform1.Show vbModeless #Else Userform1.Show #End If Note that the # characters are required. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "cecilia12345" wrote in message ... how you do this if it`s excel 2000? --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keep UserForm open at all times while excel is running | Excel Discussion (Misc queries) | |||
| Worksheet form vs. Userform...which is better? | Excel Discussion (Misc queries) | |||
| Convert Worksheet to Userform | Excel Discussion (Misc queries) | |||
| Closing the Userform when macro is running | Excel Programming | |||
| autorun userform from worksheet | Excel Programming | |||
Threaded Mode
