Hi
I am trying to create a wooksheet with drop down menu/lists, i also need the list to store any info i put into the list. so next time i dont need to type it in. any help appriciated. cheers
Hi
I am trying to create a wooksheet with drop down menu/lists, i also need the list to store any info i put into the list. so next time i dont need to type it in. any help appriciated. cheers
Good afternoon DMEAKIN1
You could use John Walkenbach's menu maker wrapper routine. Download it from here :
http://www.j-walk.com/ss/excel/tips/tip53.htm
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are 2 methods you could use for creating drop-down lists that I normally teach to people:
Data validation (restricting to a list) OR
Combo boxes
Have you tried looking into either of these methods yet? Shout if you need more explanation on either.
Cheers,
Claire
Claire Blinman
www.computertrainingsolutions.co.uk
Hi thanks fr the responses.
I am currently using the data validation method, but am constantly having to update the list. what i need is a drop down menu where if the information i require is not already in the list i can just type it in and it will be stored in the list.
I have not used Combo boxes before. can you please advise me?
Thanks
David
Hi
I am realy strugling with this now. every time i press the hide list button the whole page disapears. Can someone please tell me what i am doing wrong here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks