Hello all:
I have an excel sheet with several line shapes that I have drawn and then edited their text to include valuable information like "2 ball 2 speed 4". I then created an existing macro that automatically makes a series of option buttons, displaying the same text.
When I click on an option button, I would like the macro to select the corresponding line shape with the same text. How would I do this?
Included is a screenshot for more clarity. How would I select the macro button on the right "2 ufo 3 speed delay 3" and have excel select the line with the corresponding name (as shown). I cannot use finite macro button specific names as the range of lines and buttons will vacillate per page. There may be two, there may be twenty.
Any help is appreciated, thanks.
- Scott
Screenshot.jpg
Bookmarks