Create List in Combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

parteegolfer - 22 Mar 2006 03:54 GMT

I am attempting to create a user form with combo boxes or a drop dow
list.
How do enter the Data to be dropped down from this. I know how t
create a list using Validation however this does not help with use
forms.

Please point me in the right direction. I need three names in a box t
be selected in this user for

Reply to this Message

Steve Yandl - 22 Mar 2006 04:16 GMT

If the items are present in an existing range in your workbook, it's pretty
simple. If you select the combo box in VBE, locate the "RowSource" property
in the lower left window (Properties window). Enter the name for the range
there and you should get what you want.

Steve

> I am attempting to create a user form with combo boxes or a drop down
> list.
[quoted text clipped - 4 lines]
> Please point me in the right direction. I need three names in a box to
> be selected in this user form

Reply to this Message

Centurius - 22 Mar 2006 04:20 GMT

in the VBA window, on the properties sheet for this combo box, there is
a field named "RowSource" simply type in this field the name of the
list of data you want the combobox to contain

eg. if the combobox should call upon a list of names somewhere in the
workbook defined as FirstName
type that into the RowSource field on the properties.

if it is only the three names, and won't be changing on the sheets, you
can (i think, never actually done it) just type the options into the
RowSource field, in " " and seperated by ;

eg. RowSource "Dan";"Sarah";"Cara"
not sure if this will work, but might as well try

Hope This Helps

Cheers,
Dan

=P

Reply to this Message