+ Reply to Thread
Results 1 to 2 of 2

Combobox rowsource dependent on option buttons

  1. #1
    Registered User
    Join Date
    04-01-2016
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    56

    Combobox rowsource dependent on option buttons

    I have two option buttons on a userform, when the user clicks one of them, I need a combobox to display a dropdown selection. If they click the other option button, I need the dropdown selection to disappear and the combobox to be blank. If someone could help me with the code I'd be very grateful. I've tried an 'If' statement and a 'case', but neither has worked so far - the dropdown selection still appears whichever option you select.

    If someone could help me I'd be very grateful, thanks.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,511

    Re: Combobox rowsource dependent on option buttons

    I'm not sure if this is exactly what you mean, but should be a good starting point.

    BSB
    Attached Files Attached Files

+ 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. option buttons to determin combobox information
    By hobbsie in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-12-2014, 04:46 AM
  2. Display cells dependent on option buttons
    By inq80 in forum Excel General
    Replies: 3
    Last Post: 09-02-2014, 06:17 PM
  3. Dependent Combobox based on Option Buttons
    By Sway1978 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2013, 04:18 PM
  4. [SOLVED] ComboBox and Option Buttons
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2013, 11:54 AM
  5. [SOLVED] Option Buttons to Change ComboBox Values Dynamically
    By Stonesteel15 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2012, 11:48 PM
  6. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM
  7. Combobox: How to determine the location of the selected item if combobox has rowsource
    By ahsanzafar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2012, 03:24 PM

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