Macro code

Hi All,
I am trying to set up a IF condition on a macro associated with the submit button when the value selected from a combo box is not "All".
I repeatedly keep getting the message "Object required" which i believe is due to the fact that the macro assigned to the submit button can not resolve what the value of the combo box is.

How can this be resolve? Ane ideas?

cheers

no worries ppl...i have come up with an alternative solution....just moved the code from the module onto the current worksheet and it seems to have done the trick.....thanks aneways

cheers