Combobox help PLEASE - DESPARATELY NEED HELP!!

willlobb · Apr 4th, 2002, 01:04 PM

Is there any way to (in a user form) have a combo box that will use values from a named range of products in a worksheet, rather than having to use the AddItem method? I need to do this cos the combobox will contain a list of products but this list will be added to and the end user of my system will not know how to use AddItem. The List items need to come from the range of cells. Please help.
Thanks, Will

[ This Message was edited by: willlobb on 2002-04-04 12:14 ]

Fryer Tuck · Apr 4th, 2002, 01:34 PM

If the Combo Box is CB1, and you want the range A24 to E29, you could put in the following in a line of code:

CB1.RowSource = "A24:E29"

Of course, you could assign the range to the RowSource property directly, while setting up your form.

[ This Message was edited by: Fryer Tuck on 2002-04-04 12:36 ]

willlobb · Apr 4th, 2002, 01:56 PM

Thank you sooooooo much, thats ace.
Will

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

Apr 4th, 2002, 01:04 PM	#1
willlobb Board Regular Join Date: Mar 2002 Posts: 103	Is there any way to (in a user form) have a combo box that will use values from a named range of products in a worksheet, rather than having to use the AddItem method? I need to do this cos the combobox will contain a list of products but this list will be added to and the end user of my system will not know how to use AddItem. The List items need to come from the range of cells. Please help. Thanks, Will [ This Message was edited by: willlobb on 2002-04-04 12:14 ]

Apr 4th, 2002, 01:34 PM	#2
Fryer Tuck Board Regular Join Date: Mar 2002 Posts: 64	If the Combo Box is CB1, and you want the range A24 to E29, you could put in the following in a line of code: CB1.RowSource = "A24:E29" Of course, you could assign the range to the RowSource property directly, while setting up your form. [ This Message was edited by: Fryer Tuck on 2002-04-04 12:36 ]

Apr 4th, 2002, 01:56 PM	#3
willlobb Board Regular Join Date: Mar 2002 Posts: 103	Thank you sooooooo much, thats ace. Will