+ Reply to Thread
Results 1 to 3 of 3

VBA code: appear items of option button to a listbox

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Post VBA code: appear items of option button to a listbox

    Hello!

    Is it possible to assign items in an option button and when selected the items will appear in a list box for users to view?

    I have a userform with 4 option buttons, 1 list box, and a command button. What I want is to assign specific items in each option buttons, and whenever an option button is selected, the user will be able to view the items in the list box and select those items to be populated in the worksheet through a command button.

    Please help me.....

    hydz1213

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: VBA code: appear items of option button to a listbox

    Do you mean the items in the listbox will vary based on which option button is selected?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    01-15-2013
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Post Re: VBA code: appear items of option button to a listbox

    Quote Originally Posted by Norie View Post
    Do you mean the items in the listbox will vary based on which option button is selected?
    Yes, Norie. Thank you for clarifying that.

    Please help.... thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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