Ask Experts Questions for FREE Help !
Ask
    ronex's Avatar
    ronex Posts: 15, Reputation: 1
    New Member
     
    #1

    Dec 7, 2008, 09:53 AM
    Using comboboxes

    Well how do we place the combo box and the list of names on it...
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Dec 7, 2008, 06:20 PM

    I couldn't find the message/thread you moved it to. Did you change forums, too?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #3

    Dec 7, 2008, 06:54 PM

    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #4

    Dec 8, 2008, 09:27 AM

    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.
    ronex's Avatar
    ronex Posts: 15, Reputation: 1
    New Member
     
    #5

    Dec 9, 2008, 09:22 AM

    That was a real help thanks a looot
    ronex's Avatar
    ronex Posts: 15, Reputation: 1
    New Member
     
    #6

    Dec 9, 2008, 09:35 AM
    Hey jbeaucaire... that was the perfect fit... tanku onece again,I tried it it was just what I wanted.. thannnnxx
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #7

    Dec 9, 2008, 05:04 PM

    My pleasure. I use those combo boxes every day.
    TheCodeCageTeam's Avatar
    TheCodeCageTeam Posts: 4, Reputation: 1
    New Member
     
    #8

    Jan 15, 2009, 05:31 PM
    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Using comboboxes [ 3 Answers ]

What is the use of combo box in the excel...


View more questions Search