Annoying Embed Combo Box

[yorrick]

I am trying to insert a Combo Box so that when the user selects an option it returns a number into another cell.

Sounds easy right?

However, when I insert the combo box from the Toolbox it plants the box but it is embedded.

=EMBED("Forms.ComboBox.1","")

This means I can't edit the Input range or specify the return cell.

Very annoying - please help

 

[xlbo]

You must 1st go into "design" mode
to get there, either click on the "set square" button on the controls toolbox or the visual basic toolbars. You may then right click on the control and choose "properties"

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[yorrick]

Makes no difference unfortunately.

 

[xlbo]

ok - I see your issue. You are used to dealing with combo boxes from the FORMS toolbar. You have used a combo box from the CONTROLS toolbar. This combo box does not have those specified properties (but has similar ones plus a lot more besides). If you want your "Input Range" property you should use the combo box from the FORMS toolbar

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

The property name for a CONTROL TOOLBOX combo box for the input range is ListFillRange, and the return cell property is called LinkedCell. BUT, this returns the actual item. Use the FORMS toolbar combo box to return the item number to a cell.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[yorrick]

Great thanks Guys