RowSource for Sheet ComboBox

[Minitman]

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

 

[akphidelt]

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]

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

 

[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