View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Combobox setting

Controls are not part of a worksheet, but are in a layer above the
worksheet. Also, comboboxes don't have to be linked, so where would they be
positioned then.

This code shows how to align it to a cell, but it won't move with any
worksheet changes.

With ActiveSheet.ComboBox1
.Left = Range("C3").Left
.Top = Range("C3").Top
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Pat" wrote in message
...
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