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

    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!