Autofilter by Combo Box Selection

  • Thread starter Thread starter rob m
  • Start date Start date
R

rob m

I am looking to autofilter a worksheet to show the items that do not
equal the selection in a conbo box. Does anyone know the code to
autofilter by 'does not equal' the combobox selection.

Regards

Rob M
 
The easiest way to see the code is to turn on the macro recorder
(tools=>Macro=>Record a new macro) and perform the action manually. The
turn it off and look at the code. I believe the criteria will use the not
equal to symbol "<>"
 
Thanks for your reply. However the data I would like to filter by is in
a cell in another workbook. I can get the filter to work when it is
equal to but when I try to use the "<>" equal it gives me an error.
 
Back
Top