+ Reply to Thread
Results 1 to 5 of 5

drop down menus

  1. #1
    Registered User
    Join Date
    01-05-2007
    Posts
    5

    drop down menus

    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

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    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.

  3. #3
    Registered User
    Join Date
    01-26-2007
    Location
    Bristol
    Posts
    7
    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

  4. #4
    Registered User
    Join Date
    01-05-2007
    Posts
    5
    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

  5. #5
    Registered User
    Join Date
    01-05-2007
    Posts
    5
    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1