| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use a worksheet while running a userform?
Probably the most basic question in userform programming:
I have created a userform in excel 97. When I run the userform it works perfectly, but I cannot modify the worksheet (cells etc). I can access the worksheet through buttons on the userform (for instance ref-edits), but I cannot actually work with the worksheet. What I want to create is a userform that hangs around in the background until you need it. Advice will be appreciated :) Leo --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use a worksheet while running a userform?
Leo,
You are talking about modeless forms, which are not supported in Excel 97. You can make a 97 form modeless using a technique described by Stephen Bullen at http://www.bmsltd.co.uk/DLCount/DLCo...delessForm.zip .. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Leo" wrote in message ... Probably the most basic question in userform programming: I have created a userform in excel 97. When I run the userform it works perfectly, but I cannot modify the worksheet (cells etc). I can access the worksheet through buttons on the userform (for instance ref-edits), but I cannot actually work with the worksheet. What I want to create is a userform that hangs around in the background until you need it. Advice will be appreciated :) Leo --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use a worksheet while running a userform?
That was exactly it! I havnŽt figured out how it works yet, and if
donŽt IŽll be back. Thanks. Le -- Message posted from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use a worksheet while running a userform?
|
|
#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/ |
| Reply |
| 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 | |||
Linear Mode
