General discussion

Locked

Excel Cell Sizing With Dropdown Boxes

By stuart.douglas ·
I’ve inserted a dropdown box into an Excel spreadsheet using the form toolbar. I’m trying to get the dropdown to move and size with the cell I’ve placed it in. When I right click on the dropdown and go into format control/properties and try and select the “move and size with cells” option its greyed out and cant be selected. Why can’t I choose this option?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Cell Sizing With Dropdown Boxes

by DKlippert In reply to Excel Cell Sizing With Dr ...

The list boxes from the Forms toolbar can not be sized with the cell.
Control bar boxes can be sized, but they're controlled with macros

Collapse -

Excel Cell Sizing With Dropdown Boxes

by DKlippert In reply to Excel Cell Sizing With Dr ...

Here's a follow up. Create your input list in an unobtrusive place. Name it ? Select the range and go to Insert>Name Define.
Bring up the Control toolbar.
Hold down the Alt key while you draw the list box, if you want the box to conform to the cell.
Right click and choose Properties.
Locate ListFillRange and enter the Range name. Also add the address for the LinkedCell.
Close the Property box. Right click the Control and choose Format Control. Choose the Move and size with cells option. Click OK
Now close Design mode by clicking the Design mode icon on the Control toolbar.

Collapse -

Excel Cell Sizing With Dropdown Boxes

by stuart.douglas In reply to Excel Cell Sizing With Dr ...

Nice one this is the perfect answer thanks DKlippert, you get the points.

Collapse -

Excel Cell Sizing With Dropdown Boxes

by stuart.douglas In reply to Excel Cell Sizing With Dr ...

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums