Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I want to automatically change commandbutton text when a user types the text into a userform - Can this be done? Any Ideas? Cheers Peter (New to VBA!) -- peter.thompson ------------------------------------------------------------------------ peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686 View this thread: http://www.excelforum.com/showthread...hreadid=494305 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can double-click on the text. Then you can use the following code in you
textbox_change event: Private Sub TextBox1_Change() CommandButton1.Caption = "hhhh" 'Add this line to your textbox_change sub End Sub The commandbotton's text will be change to "hhhh". Best Regards John Black "peter.thompson" wrote in message news:peter.thompson.205xsn_1134787201.826@excelfor um-nospam.com... I want to automatically change commandbutton text when a user types the text into a userform - Can this be done? Any Ideas? Cheers Peter (New to VBA!) -- peter.thompson ------------------------------------------------------------------------ peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686 View this thread: http://www.excelforum.com/showthread...hreadid=494305 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change CommandButton Picture | Excel Programming | |||
Hiding A TextBox On A UserForm Under A CommandButton | Excel Programming | |||
CommandButton - Userform | Excel Discussion (Misc queries) | |||
Combobox with Commandbutton in Userform! | Excel Programming | |||
Commandbutton in UserForm to run Macro | Excel Programming |