Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Using comboboxes (https://www.askmehelpdesk.com/showthread.php?t=289539)

  • Dec 7, 2008, 09:53 AM
    ronex
    Using comboboxes

    Well how do we place the combo box and the list of names on it...
  • Dec 7, 2008, 06:20 PM
    JBeaucaire

    I couldn't find the message/thread you moved it to. Did you change forums, too?
  • Dec 7, 2008, 06:54 PM
    ScottGem

    First its not a good idea to piggyback your question on someone else's. This can lead to confusion. You should start a new thread. So I've moved your question to its own thread.

    Check Excel Help on combos for specific instructions
  • Dec 8, 2008, 09:27 AM
    JBeaucaire

    Combobox can be created a couple of ways.

    The one I use the most often is by Data Validation. Click on the cell, and select Data > Validation.

    Validation Criteria - Allow: = List
    Source: =

    For the source, you can manually enter the list with each item separated by a comma:

    dog,cat,bird,lizard,hamster

    Or you can put this list on the spreadsheets somewhere in cells, then put in a reference to those cells:

    =A2:A5

    Does this give you enough to get started? Read up in the Excel help files on Data Validation / List examples.
  • Dec 9, 2008, 09:22 AM
    ronex

    That was a real help thanks a looot
  • Dec 9, 2008, 09:35 AM
    ronex
    Hey jbeaucaire... that was the perfect fit... tanku onece again,I tried it it was just what I wanted.. thannnnxx
  • Dec 9, 2008, 05:04 PM
    JBeaucaire

    My pleasure. I use those combo boxes every day.
  • Jan 15, 2009, 05:31 PM
    TheCodeCageTeam
    I'm afraid that is not a ComboBox, it's a Dropdown and can only be located at a cell, a combobox can be given a position on the screen and is much more versatile when it comes to manipulating your worksheet, using a combobox allows you to programmatically have other things happen when a value is selected, be aware that a dropdown has limitations.
    Quote:

    Originally Posted by JBeaucaire View Post
    Combobox can be created a couple of ways.

    The one I use the most often is by Data Validation. Click on the cell, and select Data > Validation.

    Validation Criteria - Allow: = List
    Source: =

    For the source, you can manually enter the list with each item separated by a comma:

    dog,cat,bird,lizard,hamster

    Or you can put this list on the spreadsheets somewhere in cells, then put in a reference to those cells:

    =A2:A5

    Does this give you enough to get started? Read up in the Excel help files on Data Validation / List examples.


  • All times are GMT -7. The time now is 09:23 AM.