Solved

Excel 2010 VBA Sheet Rename

Posted on 2014-04-06
3
554 Views
Last Modified: 2014-04-06
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,

Bill
0
Comment
Question by:cowboywm
  • 2
3 Comments
 
LVL 41

Expert Comment

by:pcelba
ID: 39981852
I am sure it is possible.

Another question which rises in my mind is: Why do you write this long question with all the explanations instead of simple test of ONE line of VBA code?
0
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
ID: 39981861
OK, you may write:

ActiveSheet.Name = "SBI " + MyProject

or

Sheets(1).Name = "SBI " + MyProject

etc.

Remember some characters are not allowed in sheet names.

Restricted characters are  / \ * ? [ ]
Following characters could also be problematic in some cases  !@#$%&()+~`"':;,.|
And the sheet name length is also restricted in Excel...
0
 

Author Comment

by:cowboywm
ID: 39982068
I'll give this a try.  The reason I try to be specific is that things get lost in the writing translation.  Since there is on dialog I choose to be as clear a possible to avoid these back an forth emails.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question