I am using Excel 2010 VBA with the following variable to get information from a text box for input into a spreadsheet:
MyProject = SBINumberTextBox.Text
I have no problem with this task.
I also want to use this variable to rename the current (active) sheet. During the renaming process, I want to start with some static text followed by the variable text.
"SBI(space)" + MyProject
So if the user enters 888 into the text box, the end result should be that the sheet is now titled SBI 888.
Is it possible to use information from a text box in this fashion?
Thanks for your expertise,