Button Name change

R

rhani111

Hi All,

Hopefully there is an easy way to do this.....

I want the text on my macro button to change if the *-Sheet-* name
changes. Is this possible?

At the moment this is my vba code
ActiveSheet.Shapes("Button 415").Select
Selection.Characters.Text = "Shot 2"
With Selection.Characters(Start:=1, Length:=7).Font
Name = "Arial"
FontStyle = "Bold"
Size = 10
Strikethrough = False
Superscript = False
Subscript = False
OutlineFont = False
Shadow = False
Underline = xlUnderlineStyleNone
ColorIndex = 1

Thanx heaps in advance
San
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing text into a Text Box 2
Macro DoSomething in every cell of my selected range 1
How to add text box with macro attached 1
Help with VBA to find data delete it change font, add lines then looptill end of file 4
Button Problem 2
Macro changes color 3
Formatting Result of Custom Function 1
Page Setup not working in macro 1

Top