ComboBoxes are a jumpin

[kcdill]

I have two combo boxes on the right side of my Appurtenances sheet that I use to choose the type of pipe or flange. Recently the ComboBoxes have been showing up on the left side of the spread sheet and I have to manually move them back over the target cells. I check the design properties and don't see any thing out of the ordinary. Anybody ever encounter this errant behavior with ComboBoxes?

 

[ChrisM]

This is a know Excel issue that is easy to fix. If you print preview your controls will move around.

In design mode, right click your combo, choose format control, choose properties tab, and change setting to "don't move or size with cells".

 

[kcdill]

Good Afternoon ChrisM:
I tried changing from "move but don't size with cells" to "don't move or size with cells" all without effect. I now remember running into this same problem about three years ago and was told to set the properties to "don't move or size with cells" which I did. I made that change and that setting seemed to work just fine for the last couple of years until recently. I just checked some other ComboBoxes on another spreadsheet in the same WorkBook and they are set at "Move and size with cells" and don't jump around. Three years ago when I had the property set at "Move and size with cells" the ComboBoxes were sliding to the left just like they are now. All of this is somewhat confusing until I remember that Excel is a MS invention and has a mind of its own. Thanks for the reply.
Regards, Kent.

 

[kcdill]

Good Afternoon Again ChrisM:
Apparently I just lied to you. Seems like the correct setting is "Move and size with cells".
Thanks again, Regards, Kent.