RowSource for Sheet ComboBox

M

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
 
A

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.
 
M

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top