Hi Murthy

You can use the change event to run your sub.
http://www.cpearson.com/excel/events.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Murthy" wrote in message ...
I want to filter the data on a sheet, basing on the value in a particular
cell - say A1.

What I have done so far is:
1) I have generated code to filter the list
2) I have provided a pick list in Cell A1
3) I have created a command button, clicking on which will execute the code
I mentioned in step (1) above.

Instead of clicking on the command button each time, is there a way to
filter the list, as soon as the value in Cell A1 is changed? Which event
should I use in my code for that?

Regards,
Murthy