Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Combo box or?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Atlanta,Ga
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Newbie needs someone to hold his hand...
    I am trying to create a combo box or? to enable the user to pick from a list. I have created a sheet with all data in seperate columns, but in the same workbook. I have tried both of the aforementioned methods, but, I just don't get it. Step-by-step anyone?
    ANY help is appreciated!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You need to identify the row from which the options or chioces that you want the user to select from. Then create a combobox or a listbox and go to the properties/row source and enter the column. When the user pulls down the combobox or veiws the listbox the list will be there.

    Hope this helps-Todd

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Atlanta,Ga
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Todd,

    Thanks for the try. I have tried to do that in the VB dialog box that pops up when you double click the combo box. Unfortunatly, I don't know what I'm doing so I am not doing it right. That's why I was hoping someone would show me a step-by-step method.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Assuming the combobox is on a sheet, in design mode, right click on the combobox, choose properties. When the properties box apears, find the row source and enter a column such as a1:a50. Is this what your looking for?

  5. #5
    New Member
    Join Date
    Apr 2002
    Location
    Atlanta,Ga
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Todd,
    Again, thanks for your help. I did not want to post a large example, but I guess, since I can't explain it well enough, I will.

    I have a workbook with, so far, 4 worksheets. They are:
    Loads, Expenses, Pay, Data
    I would like to create either combo boxes, or pull downs, or list boxes, or? on each of the worksheets ( Pay, Loads, Expenses ).

    The info, like Driver name's, expense items, and load details would come from one sheet in the same workbook ( Data ).
    I have never done anything like this, and have zero programming experience, let alone VB.
    I hope my feeble attempt to explain more fully, will help you to help me.

    Maybe I should add that I have set my data sheet up like this:

    a1:a999 are the driver names
    c1:c999 are the acct'g weeks ( wk1:wk52 )
    e1:e999 are the load item details
    g1:g999 are expense items
    and there will be more to come. I'd just like to get this far for now!
    Thanks,
    Wesley

    [ This Message was edited by: itsmewhoelse on 2002-04-23 11:16 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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