wolf.stalker
11-06-2009, 05:24 AM
I need to populate a combo box on a worksheet. how (from module 3) do i access that combo box on worksheet(1) ?
i know it's mostlikely going to be ...combox1.additem ("item") but it's the first dam part i can't seem to get. if i was doing this to a form inside vba it would be a simple frmFormName.cmbComboBox.Additem "blah" and so on. I just can't get the syntax right for talking to the worksheet itself. :banghead:
thanks.
oh, i am using 07 if that makes a difference.
i know it's mostlikely going to be ...combox1.additem ("item") but it's the first dam part i can't seem to get. if i was doing this to a form inside vba it would be a simple frmFormName.cmbComboBox.Additem "blah" and so on. I just can't get the syntax right for talking to the worksheet itself. :banghead:
thanks.
oh, i am using 07 if that makes a difference.