Excel 2007 : Cant pass variables properly

all,

Im guessing this is a very simple thing but Im new at writing code for excel and i dont have a manual.

the situation is this. I have a table I want to filter so that I wind up with one entry displayed. I have a combobox to allow for the user to choose what to filter on. I then want to use a command button to have them actually do the filtering. the thing is I cant get the bloody command button to see the variable like .Value in the combobox.

I can get it if I call a routine within the combobox but I cant call the command button within that. Im pretty sure I need some sort of global declaration but I cant seem to get it to work.


Any help would be appreciated.


regards,
Pete

pretty sure the combobox is an activeX one.

the button is a form control button.

typing it down make me wonder if there isnt going to be a problem with using the two different ones in one form

That worked like a champ....thanx