Excel 2007 : Combo boxes and VBA

[thart21]

Hi, I am attempting to create 3 combo boxes that will pull source data over from another worksheet in my workbook.

I don't need them to be dependent upon each other, I am fairly new to Excel programming (use Access and some VBA mostly) and can't seem to find the right keyword(s) to search on for what I need.

I have attached a pic of what I am looking for.

cboMonth
cboDept
cboOrderType

I can get the combo boxes populated with my lists of data, just need to find out how to add VBA to have it change the corresponding data below the combo boxes by pulling the data from the source worksheet. I have seen the VLOOKUP method but am hoping there is an easier VBA method to do this. I want it to change no matter what combination of combo box is chosen i.e. if they change the Month and Dept only, don't change the Order Type.

What should I be searching on? I've seen posts on Data Validation but unsure if this is what I need.

Would appreiate any help you could give me.

Thanks!

Toni