ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List Box or Combo Box (https://www.excelbanter.com/excel-discussion-misc-queries/178825-list-box-combo-box.html)

Finneous J Whoopee

List Box or Combo Box
 
When I insert a list box or combo box into a cell I am not able to select
"move and size with cells" under Format Control/Properties (greyed out).
When I copy either of them to another cell, the cell link (Format
Control/Control) will not follow to the new cell location, even when the $ is
removed from the cell reference.
How can I get these to move and size with the cells and refernce the cell
they are currently sitting on without manually updating the properties of
each one?


All times are GMT +1. The time now is 02:41 PM.

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