+ Reply to Thread
Results 1 to 3 of 3

how to find out which optionbutton was picked

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    how to find out which optionbutton was picked

    i have tried both these solutions and the both fail.
    i need to find out which option button was picked in a frame (FRAME). I have 31 buttons that go from optionbutton1 to optionbutton35. here is the code that doesn't work

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    in the last example, the typename is FRAME and not OptionButton"

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: how to find out which optionbutton was picked

    this worked for me, showing caption and control name.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    Re: how to find out which optionbutton was picked

    thanks andy, worked like a charm. appreciate the help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to pick value from the row below to the row of value already picked?
    By Abid Saeed in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-20-2017, 02:08 AM
  2. Sum of minutes picked
    By superchew in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2013, 08:29 PM
  3. Excel 2007 : ID to be picked up
    By sushil10s in forum Excel General
    Replies: 1
    Last Post: 02-09-2012, 05:35 AM
  4. data to be picked from description
    By saifeesl in forum Excel General
    Replies: 1
    Last Post: 06-26-2011, 08:10 AM
  5. how to have dynamic vlaues picked up
    By vikkam in forum Excel General
    Replies: 5
    Last Post: 09-12-2008, 10:49 PM
  6. Range is not being picked up
    By Sheeny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2006, 03:00 PM
  7. Range is not being picked up
    By Sheeny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2006, 03:00 PM

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