Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello--does anyone know how to set the caption on a command button of a
userform equal to a variable generated in a main procedure (in which the userform procedure is loaded and displayed). Thanks, Abe |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Akh,
In a standard module, before any code, paste the fillowing code: '============= Option Explicit Public strCaption As String '--------------- Public Sub Tester() strCaption = "Your Caption" UserForm1.Show End Sub '<<============= In the useform module, try: '============= Private Sub UserForm_Initialize() Me.CommandButton1.Caption = strCaption End Sub '<<============= --- Regards, Norman wrote in message oups.com... Hello--does anyone know how to set the caption on a command button of a userform equal to a variable generated in a main procedure (in which the userform procedure is loaded and displayed). Thanks, Abe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to elegantly end a main procedure from a userform command button? | Excel Programming | |||
Pass switch to Main procedure | Excel Programming | |||
label caption equal excel value | Excel Worksheet Functions | |||
disable X button in main window | Excel Programming | |||
setting a range variable equal to the value of a string variable | Excel Programming |