Got it! I right click on the combo box and chose format control, went to the
properties tab, then chose "don't move or size with cells." Thanks!

lonnierudd wrote:
That's a good idea but it's too big. I've already set up the sheet, and while
the formulas in the sheet would adjust if I added a couple of rows, the VBA
wouldn't and I really don't want to redo this. Also, it's very possible a
user may want to switch back and forth from 2008 to 2009 and back again. This
needs to be as user friendly and flexible as possible.

Have you thought about putting the combo box on a UserForm, then call the
UserForm up when you need to use the ComboBox. You can designate where the
[quoted text clipped - 5 lines]
(as someone here suggested) but I can't figure out how to attach macros to
the selections in the drop down box in the cell. Any ideas of how to proceed?

--
Message posted via http://www.officekb.com