Results 1 to 2 of 2

Thread: option boxs

  1. #1
    2 Star Lounger
    Join Date
    Apr 2004
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have 5 options that the user can chose from on the user form.

    a
    b
    c
    d
    e

    I am using option buttons for each one, how would I code it so that when the user
    choses one or all that they all show up in my excel spreadsheet.

    another words, say that the use clicks A, B, E - my cell should show me A B E

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,412
    Thanks
    368
    Thanked 1,451 Times in 1,320 Posts
    Here's a possible solution to your question as I understand it.
    Normally, Optionbuttons are mutually exclusive but you can get around this by setting the GroupName for each button to a different value {see attached example}.

    Use Alt+F8 & select "TestUserForm" then Run to try the form out.
    Use Alt+F11 to view the form & button properties as well as the code attached to the Save button.


    Good Luck.
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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