+ Reply to Thread
Results 1 to 3 of 3

Default Option Button Values

  1. #1
    Registered User
    Join Date
    04-05-2007
    Location
    Sydney Australia
    Posts
    48

    Default Option Button Values

    Hi All

    I have created a userform with 4 OptionButtons and a ListBox. The buttons are in groups. 1 and 2 are one group, 3 and 4 next group.

    I would like to know how to have the value of OptionButtons 1 and 3 be True each time the userform is open.

    I would also like them to default to True each time the listbox changes.

    Any help is greatly appreciated.

    Thanks

    Jeff
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Jeff,

    I changed your macro a little and added some code to the ListBox and UserForm event procedures. All these changes have been added to the attached workbook.

    Macro to Show the Form
    Please Login or Register  to view this content.
    Code to Set the Option Labels
    Please Login or Register  to view this content.
    Code to Set Options True when ListBox Changes
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-05-2007
    Location
    Sydney Australia
    Posts
    48

    Thanks

    Hi Leith

    Thanks very much for your reply and solution. The help you guys provide here is fantastic.

    Kind Regards

    Jeff

+ 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