Combo/List Box

[David Fixemer]

Not really a "Programming/Macro" question, but why how do
I have my combo/list boxes move and resize with a specific
cell? This specific properties option is grayed out and I
cannot select it.

Thanks in advance,

David Fixemer

 

[Dave Peterson]

You used the listbox and combobox/dropdown from the Forms toolbar.

The list box and combobox from the Control Toolbox toolbar have this option
enabled.

They behave similarly, but different (huh?).

Instead of rightlclicking on the Forms dropdown and choosing Format Control to
set the input range and cell link, you enter design mode (an icon also on the
control toolbox toolbar) and then right click on the control and select
properties.

You can see lots more stuff here--right click|format control is still available
for other things, too.