ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo/List Box (https://www.excelbanter.com/excel-programming/292026-combo-list-box.html)

David Fixemer

Combo/List Box
 
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[_3_]

Combo/List Box
 
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.



David Fixemer wrote:

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



All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com