I am trying to code a global Sub (vs. Private Sub) but using very worksheet specific criteria... but not sure how to code the objects. For example, I want to say IF value of combobox1 in Sheet1 (or "Options") equals "section 1", then go to cell A1 in Sheet2 (or "Admin"). Else, if value of combobox1 in Sheet1 (or "Options") equals "section 2", then go to cell A20 in Sheet2.

I don't know how to code the combobox object in Sheet1.

I'm thinking it's something like Sheet1.combobox1.value = "section 1"

But I'm having no LUCK...

Can someone help???