That works but I can't change the background color.

How do I access the other ComboBox properties or are they not
available in the forms menu?

-'Minitman


On Mon, 24 Mar 2008 11:26:05 -0700, akphidelt
wrote:

Most likely you are using a Control Toolbox Combo Box.

What you want to do is go to

Tools--Toolbars--Forms

After clicking on forms a little toolbox will show up, click on the combo
box. Then when you right click it go to the Format Control tab and type in
the Named Range in the Input range.

"Minitman" wrote:

Greetings,

I have a sheet with a ComboBox on it.

I need to load a named range into this ComboBox's RowSource property.

How do I do that?

Any help would be greatly appreciated.

-Minitman