View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default Combobox setting

Pat wrote:
Why would a combobox not align itself to the cell in which it is
linked to. If for example the properties LinkedCell setting is
showing it to be H20 the combobox will sit several cells above rather
than sit over the cell it is linked to.

Any idea why this should be?

Pat


The linked cell only controls the value of the combobox, not its
position.... you'll have to move it using VBA or set its properties to not
move or resize with cells.

--
Regards,

Juan Pablo González