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
Bookmarks