+ Reply to Thread
Results 1 to 4 of 4

Check Boxes / Radio Buttons

Hybrid View

  1. #1
    Registered User
    Join Date
    11-17-2005
    Location
    Georgia
    Posts
    82

    Check Boxes / Radio Buttons

    I have a sheet that the user can select a single part number using a Radio Button. This works fine but I would like to use Check boxes for a couple of reasons:

    1. I Like them better visually
    2. Click once to select, click again to de-select

    Is there any way to make check box's behave similar to a radio button in that only one can be selected at a time (it is OK to have nothing selected as well)

    I know that I can do this with code, but I am runnig about 20 boxes and the code gets to be a pain just to deselect the other boxes. Can you set up an "array" of controls similar to how it can be done using .NET programming so that all of the boxes could be looped through rather than addressing each one by a unique name? (have all controls point to a single subroutine)

    Thanks for any insights or suggestions

    Lee

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    If you are using Forms option buttons or check boxes, there is no difficulty at all to add a group box ...
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    11-17-2005
    Location
    Georgia
    Posts
    82
    These check boxes are placed directly on a sheet, not a form. Can I group them on a shhet as well?

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Yes ...

    View ToolBars Forms
    Group box

+ 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