Combo box dependent on Option Buttons

    Hi Everyone


    I am relatively new to VBA.
    I have an User form that will be designed to create a quote. It has multiple sheets in the background. The user will select the various options for the project.
    I am struggling to create the form so that when they select option button 1 then the combo box populates with certain data, when the select combo box 2 it populates with other data etc...
    Thinking If statement would be the best..


    If OptionButton1 = True Then
    'ComboBox3.Rowsource=Worksheets("Sheet2").Range(C2:C5)


    Can anyone guide me in the right direction?

    Re: Combo box dependent on Option Buttons


    You're description is a little vague.


    What you're trying should work. Does it not?


    Search for cascading comboboxes.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login