Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show user form, leave wosksheet active
I just want to display a warning to users while the sheet is open, but leave the worksheet active. Sounds simple, but I can't find the answer. Any help would be appreciated.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show user form, leave wosksheet active
Hi Wric,
You have to have at least Excel 2K, and set the ShowModal property of the userform to false. Regards, Greg "Wric Smith" wrote in message ... I just want to display a warning to users while the sheet is open, but leave the worksheet active. Sounds simple, but I can't find the answer. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show user form, leave wosksheet active
If you have Excel 2000 or later, show your userform as vbModeless
Userform1.Show vbModeless -- Regards, Tom Ogilvy "Wric Smith" wrote in message ... I just want to display a warning to users while the sheet is open, but leave the worksheet active. Sounds simple, but I can't find the answer. Any help would be appreciated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show user form, leave wosksheet active
Thanks. I just wish I knew enough to know what i'm looking for. You guys are Great!
----- Tom Ogilvy wrote: ----- If you have Excel 2000 or later, show your userform as vbModeless Userform1.Show vbModeless -- Regards, Tom Ogilvy "Wric Smith" wrote in message ... I just want to display a warning to users while the sheet is open, but leave the worksheet active. Sounds simple, but I can't find the answer. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show user form | Links and Linking in Excel | |||
SHow user form when opening workbook | Excel Discussion (Misc queries) | |||
Tools/Options/Charts-Active cells is dimmed. Want to select leave | Charts and Charting in Excel | |||
Update Macro: Leave Colour As Before Once Cell is Not Active | Excel Discussion (Misc queries) | |||
Use a text box to calculate and show results in a user form | Excel Discussion (Misc queries) |