Combo box moves by itself

[GO GaryFingers]

I have a combo box, made from (Active X control), When I use a custom view, to view elsewhere on the sheet, the combo box slides over to the left.

I've gone to the format options, and checked "do not move or size with cells", but it is still moving.

PS I have'nt been able to figure out what to do regarding an Initialization sub for this,??

Otherwise, It functions beautifully, Go Figure

 

[GO GaryFingers]

Dugh?, I read another similar post, And I DO need to have move and size with cells checked. Apparently, this stops it from moving.

Tried it, it seems to be better!

End of Story. Next time, I'll search more Thanx anyway

 

[Andrew Poulsom]

Welcome to the Board.

I can't duplicate that behaviour (Excel 2000). What are the differences between your custom view and normal view?

The ComboBox does not have an Initialize event. You could put some code in the Workbook_Open or Worksheet_Activate events to fill it, or you could use the ListFillRange property.