If statements with combo boxes

[bynummustang]

Alright guys, I know NOTHING about VBA code, and I have to write a spreadsheet. I know some basic programming (took Fortran back in 2009) so I know the flow of how to get something to be layed out, but the VBA specific code I don't know.

Basically this is what I'm trying to do:
Have a combo box with 5 options. Based on which option is selected, it will populate another combo box with 5-9 more choices. Based on the options selected in both combo boxes, it will then be linked to .pdf which will be hosted on a local server.

IF COMBOBOX_1 = "OPTION 1" THEN
*BRING UP COMBOBOX 2 (BASED OFF OF COMBO BOX 1 SELECTION)*

ELSEIF COMBOBOX_1 = "OPTION 2" THEN
*BRING UP COMBOBOX 2 (BASED OFF OF COMBO BOX 1 SELECTION)*

And have that kind of code for the 5 options in my first combo box. Then use a differnt if statement to bring up a certain .pdf based on the two selections.

Any help would be greatly appriciated.

Thanks,

Jordan

 

[bynummustang]

Bump.