View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default RowSource for Sheet ComboBox

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