Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activesheet.shapes("Group 1...n")
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
activesheet.shapes("Group 1...n")
Solved this much more easily...
ActiveSheet.Shapes("option button 34").Select Selection.Characters.Text = "Per User" Thanks brain! Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help displaying "Maximum" or "Minimum" if cell is max or min in a group? | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming |