Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add Menu to XL Worksheet (Windows 2000 - XP)

    Hi, Does anyone know how I could add a pull down menu to a spreadsheet. I do not want to use a data verification box unless it can be made to look like a regular pull down menu, nor a custom menu in the excel tool bar. What I am looking for is an always visible pull down menu right on the work sheet to replace a bunch of messy radio buttons, check boxes and control boxes. Please give me your suggestions if you can help. Thank you

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add Menu to XL Worksheet (Windows 2000 - XP)

    Welcome to Woody's Lounge!

    You can place a combo box on the worksheet from the Forms toolbar, or from the Control Toolbox. The one from the Forms toolbar is slighty easier to use. If you right-click it and select Format Control from the popup menu, you can set the input range (the range of cells used to populate the dropdown list) and the linked cell. The linked cell will contain the index of the selected item (i.e. if the user clicks the 3rd item in the list, the linked cell will contain 3)

Posting Permissions

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