View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
john john is offline
external usenet poster
 
Posts: 4
Default 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