Combo box or?

itsmewhoelse · Apr 23rd, 2002, 11:35 AM

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!

Todd_M · Apr 23rd, 2002, 11:43 AM

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

itsmewhoelse · Apr 23rd, 2002, 11:51 AM

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.

Todd_M · Apr 23rd, 2002, 11:56 AM

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?

itsmewhoelse · Apr 23rd, 2002, 12:10 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 11:35 AM	#1
itsmewhoelse New Member Join Date: Apr 2002 Location: Atlanta,Ga Posts: 7	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!

Apr 23rd, 2002, 11:43 AM	#2
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	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

Apr 23rd, 2002, 11:51 AM	#3
itsmewhoelse New Member Join Date: Apr 2002 Location: Atlanta,Ga Posts: 7	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.

Apr 23rd, 2002, 11:56 AM	#4
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	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?

Apr 23rd, 2002, 12:10 PM	#5
itsmewhoelse New Member Join Date: Apr 2002 Location: Atlanta,Ga Posts: 7	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 ]