How to get a form to select a range based on a filter?

[qjd2004]

Hiya,

How can I get a form to give the user a list of values in column B and which ever one they select, all rows from A to AM where the value in B is the one they selected get activated/selected (so I can then do something with them in my code)?

Any help much appreciated as I don't know much about assigning events and such like.

 

[PHV]

Take a look at the AutoFilter object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884