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

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

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

OPPS!!!

I just realized that I don't know how to use this ComboBox value in a
formula!

Could someone give me an example of how to use the value in the
ComboBox as the reference in a Vlookup formula?

Any help is appreciated, thanks.

-Minitman

On Mon, 24 Mar 2008 16:30:34 -0500, Minitman
wrote:

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