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!)
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!)
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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks