You could easily use the value selected in DV in your macro.
BTW, that website was
http://www.contextures.com/xlDataVal01.html
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"snax500" wrote in message
...
I wanted to have it within the macro so that a listbox pops on the
screen, the user chooses the name and then my macro takes the user
picked name and filters the data. I did not want data validation.
On Mar 3, 4:35 pm, "Bob Phillips" wrote:
How about Data Validation? Debra Dalgleish has details on her website at
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"snax500" wrote in message
...
In Excel2000, I have the following code in a macro...
NAME = Application.InputBox("Type in Name to be filtered")
I want the user to use a list box ( with references to
range("o34:o50") instead of InputBox, less chance for spelling errors.
How do I replace the code?
Thanks- Hide quoted text -
- Show quoted text -