Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If I do the following...
with userform1 .textbox1.value = "Some text to display" .show (modal) end with The form displays but the text box doesn't show. It's as if the form had no controls. However, if I add a msgbox command... with userform1 .textbox1.value = "Some text to display" .show (modal) msgbox "Press OK to continue.." end with The modal form displays correctly. How can I get the modal form to do what I want without having to wait for input, which defeats the whole purpose of using a modal form to pass information? Regards, John M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
display userform | Excel Discussion (Misc queries) | |||
UserForm: force to update controlsources | Excel Programming | |||
How to cause userform to display | Excel Programming | |||
How? Force Sheet1 to display each time the workbook is opened. | Excel Programming | |||
Must be a way to force focus back to sheet instead of UserForm - isn't there? | Excel Programming |