PDA

View Full Version : VBA to change content at the click of button



arnab0711
01-18-2012, 02:45 AM
Hi,
I have this workbook attached where in sheet2 there and some command button and an UI,now I want at the click of each command button the writing of UI will change.for example at the click of 2nd command button the write up of the UI will change to the write up as shown in column M-P
Thanks

Bob Phillips
01-18-2012, 05:46 AM
With ActiveSheet

.Shapes("TextBox 53").TextFrame.Characters.Text = .Shapes("TextBox 62").TextFrame.Characters.Text
End With

arnab0711
01-18-2012, 06:15 AM
Thanks for the solution.