Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring Captions/Text between UserForms
This might be hard to explain...
I have a useform with 24 buttons and 24 textboxes. Each button corresponds to a textbox next to it. The idea is to click a button to open up another userform with several optionbuttons, then click the optionbutton and have the optionbutton caption be put into the textbox that corrisponds to the button that was originally clicked. (hope that makes sense) I have tried assigning a variable (as String) to pass between the userforms, but the caption gets lost (comes back blank). (on UserForm1) Private Sub cmdbutton_Click() Dim myVar as String buttonbox.Text = myVar UserForm2.Show End Sub (on UserForm2) Private Sub optionbutton1_Click() myVar = optionbutton1.Caption Unload Me End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring text from one worksheet to another | Excel Discussion (Misc queries) | |||
Formatting Text Boxes & Label Captions in MultiPages | Excel Programming | |||
transferring from excel to text | New Users to Excel | |||
Sending/Transferring Text? | Excel Programming | |||
Transferring data entered into a Text box to another Cell/Sheet? | Excel Programming |