+ Reply to Thread
Results 1 to 2 of 2

Selecting Line shape based on selected Option Buttons' text

  1. #1
    Registered User
    Join Date
    04-21-2013
    Location
    LA, CA
    MS-Off Ver
    Excel 2003
    Posts
    12

    Selecting Line shape based on selected Option Buttons' text

    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

  2. #2
    Registered User
    Join Date
    04-21-2013
    Location
    LA, CA
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Selecting Line shape based on selected Option Buttons' text

    Sorted -- I have to select the macro/option button first, and only then does the variable of the Text become available to me.

    Please Login or Register  to view this content.
    Last edited by Scott_Dreppan; 04-26-2013 at 01:27 PM. Reason: Grammatical clarity

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1