MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comboboxes embedded in a worksheet


Posted by James on September 03, 2001 10:22 AM

Hello.

I`ve got quite a few comboboxes on a worksheet and would like to fill them all with the same selection values. How can I do this without having the code go like this

With combo1
.additem "value 1"
.additem "value 2"
etc
end with

With combo2
.additem "value 1"
.additem "value 2"
etc
end with

with combo3
.additem "value 1"

and so on

If you could help then this would save me a load of time.

Many thanks

James, (I`ve trying to do this all day)


Posted by Rob Jackson on September 04, 2001 12:01 AM

IF your lists are Identical then you could create a list on another sheet and set the RowSource property to pick it up from there.
Alternatively, have you considered data validation?

Rob

Posted by James on September 04, 2001 1:29 AM

Hi Rob. Thanks for the reply. I found some info on data validation and have used this. Seems easier than trying to figure out a macro. Many thanks

James