| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stay as do it - userform
Hi,
I've two userforms. One is userform info "please wait..." second is form in subs. I'd like hold userform.show "please wait.." as long as sub in second userform was performed. Any advice appreciated Regards Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stay as do it - userform
Probably easier to just put you message on the single userform.
You could make the other controls visible = false and unhide your message. Then reverse the process. After setting the attributes, do a doevents to enable the screen to redraw. -- Regards, Tom Ogilvy "Mark" wrote in message ... Hi, I've two userforms. One is userform info "please wait..." second is form in subs. I'd like hold userform.show "please wait.." as long as sub in second userform was performed. Any advice appreciated Regards Mark |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stay as do it - userform
Mark,
You would either have to have modeless forms (XL2000 or later), or load the second form from form1, and perform the code from within form2, and then close it down itself. -- HTH Bob Phillips "Mark" wrote in message ... Hi, I've two userforms. One is userform info "please wait..." second is form in subs. I'd like hold userform.show "please wait.." as long as sub in second userform was performed. Any advice appreciated Regards Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell to stay same | Excel Discussion (Misc queries) | |||
| Need formula to STAY | Excel Worksheet Functions | |||
| Access from add_in userform to main template userform.... | Excel Programming | |||
| Linking userform to userform in Excel 2003 | Excel Programming | |||
| Stay in TextBox | Excel Programming | |||
Linear Mode
