View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Finneous J Whoopee Finneous J Whoopee is offline
external usenet poster
 
Posts: 1
Default 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?