Change commandbutton text from userform
 

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

Change commandbutton text from userform
 

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