activesheet.shapes("Group 1...n")

[Andreww]

Hi - I have some radio/option buttons inside a group box which is then
all grouped together and locked in place.

I want to be able to (use VBA) to change the option button text. When
I record a macro and then try and rerun it with different text, I get
a message "The item with the specified name doesn't exist"

Code is

ActiveSheet.Shapes("Group 4").Select
Selection.ShapeRange.Ungroup.Select
ActiveSheet.Shapes("Group Box 1").Select
ActiveSheet.Shapes("Option Button 2").Select
Selection.Characters.Text = "Cheese"

Then when I check the name of the "group... " it's incremented by 1!

Any ideas how I can change the button text??

Thanks

Andrew

 

[Andreww]

Solved this much more easily...

ActiveSheet.Shapes("option button 34").Select
Selection.Characters.Text = "Per User"

Thanks brain!

Andrew