+ Reply to Thread
Results 1 to 5 of 5

selecting multiple optionbuttons within frame help

  1. #1
    Registered User
    Join Date
    10-21-2013
    Location
    bellingham, washington
    MS-Off Ver
    Excel 2003
    Posts
    32

    selecting multiple optionbuttons within frame help

    Hello,

    I have attached an example workbook; hopefully this is a simple fix.
    You will find three frames each with multiple option buttons.

    I would like to be able to select multiple option buttons within each frame.

    Thanks you for all of the help!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-21-2013
    Location
    bellingham, washington
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: selecting multiple optionbuttons within frame help

    Someone just suggested I use checkboxes not optionbuttons?

    Any thoughts on this?

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: selecting multiple optionbuttons within frame help

    I think you mean you want to select one option button within each frame.

    The OptionButton has a property called GroupName. This determines what group the option button is in. Only one button in a group can be selected at a time.

    Decide on a GroupName to use for the buttons in each frame, and then update that property in each button (click the button then press F4 to get the list of properties).


    This post is incorrect. When option buttons are in frames, they automatically are associated in a group without having to set GroupName. So I misunderstood your question.
    Last edited by 6StringJazzer; 05-20-2015 at 11:31 AM. Reason: as shown
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    10-21-2013
    Location
    bellingham, washington
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: selecting multiple optionbuttons within frame help

    Thanks but I do want to be able to select more than one option button within the frame. Its seems that my approach was incorrect and I need to use a different function other than an option button.

    I am still a rookie trying to learn how to create userforms.

    Thanks.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: selecting multiple optionbuttons within frame help

    Yes, you should use checkboxes.

+ 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] Looping through controls by frame on userform (frame within a frame)
    By njs27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2015, 10:21 AM
  2. Selecting the frame Dynamically
    By Laurelb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2015, 10:17 AM
  3. 2 OptionButtons in the same Frame
    By olio39 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-27-2007, 09:38 AM
  4. Userform selecting worksheet via Optionbuttons
    By RobertCo in forum Excel General
    Replies: 4
    Last Post: 12-28-2006, 03:41 AM
  5. Selecting OptionButtons
    By Geoff in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-16-2005, 02:05 PM

Tags for this Thread

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