Hi,
I would like to create a macro for a list of items to be available in a drop down menu.
IE.
1. Arrow
2. Boy
3. Cat
Now, they are in table form. I want them to be available for a drop down menu, how do i do it?
Thanks,
Vinish
Hi,
I think what you want to do does not require a macro. It is called data validation with a list. Read about it here:
http://www.contextures.com/xlDataVal01.html
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks