| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle between excel sheet and user form
Gents,
How can I make my forms in a way that would allow me to select the active sheet or move up and down the sheet while the user form is still shown in front of the user. Regards |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Toggle between excel sheet and user form
Omar,
In XL2000 or above, show the form as modeless. You can't do it without a lot of hacks in 97. frmName.Show vbModeless Robin Hammond www.enhanceddatasystems.com "Omar" wrote in message ... Gents, How can I make my forms in a way that would allow me to select the active sheet or move up and down the sheet while the user form is still shown in front of the user. Regards |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Toggle between excel sheet and user form
Robin,
You are the best - it works perfectly. Thanks. "Robin Hammond" wrote: Omar, In XL2000 or above, show the form as modeless. You can't do it without a lot of hacks in 97. frmName.Show vbModeless Robin Hammond www.enhanceddatasystems.com "Omar" wrote in message ... Gents, How can I make my forms in a way that would allow me to select the active sheet or move up and down the sheet while the user form is still shown in front of the user. Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel form - How create toggle checkmark for Yes or No ? | Excel Discussion (Misc queries) | |||
| User form browsing for a range on a sheet? | Excel Programming | |||
| Displaying part of a sheet on a user form | Excel Programming | |||
| Copy from User form to Sheet macro | Excel Programming | |||
| How to set focus back to sheet after showing a user form | Excel Programming | |||
Linear Mode
