Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic form updates
I have a userform in VBA setup the way I need it.
I would like to have 3 different Subs use the form. When the sub calls the form to show, how can I change the Form Title in the Blue bar across top, And what a certain label on the form say? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic form updates
OK I figured out how with Globals but, is there
anyway to do it with out Global Variables? I can do it with Globals, but would like to stay away from those if possible. Thanks, "Shawn G." wrote: I have a userform in VBA setup the way I need it. I would like to have 3 different Subs use the form. When the sub calls the form to show, how can I change the Form Title in the Blue bar across top, And what a certain label on the form say? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic form updates
One way is to store the required userform title and caption for the label in
either two public variables or in a specific worksheet location, before each sub calls the userform these values are set, and the userform intialize event loads the values into the form. -- Cheers Nigel "Shawn G." wrote in message ... I have a userform in VBA setup the way I need it. I would like to have 3 different Subs use the form. When the sub calls the form to show, how can I change the Form Title in the Blue bar across top, And what a certain label on the form say? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Updates on Compiled Worksheet | Excel Worksheet Functions | |||
How can I set up a dynamic data entry form? | Excel Worksheet Functions | |||
Dynamic Chart updates | Excel Programming | |||
Linking dynamic Cells in Excel to Form | Excel Programming | |||
Dynamic Form | Excel Programming |