Combo box Row source
 

Hello,

Hope, someone can help me here.

Since I only have 3 list the I want user to select it from the conbo box, I
want to type list of combox data in the "RowSource" in the Property.

How can I do this? Anyone can help me out here?

Thanks

Combo box Row source
 

Try the .AddItem method to assign the values

RowSource can only be a cell reference back to an excel worksheet or range
name.

--
Regards,
John


"Richard" wrote:

Hello,

Hope, someone can help me here.

Since I only have 3 list the I want user to select it from the conbo box, I
want to type list of combox data in the "RowSource" in the Property.

How can I do this? Anyone can help me out here?

Thanks

Combo box Row source
 

Instead of using a combobox, you may want to look at Data|Validation. It's much
easier to implement and acts kind of like a combobox.

Debra Dalgleish has lots of tips:
http://contextures.com/xlDataVal01.html

Richard wrote:

Hello,

Hope, someone can help me here.

Since I only have 3 list the I want user to select it from the conbo box, I
want to type list of combox data in the "RowSource" in the Property.

How can I do this? Anyone can help me out here?

Thanks

--

Dave Peterson