I have been seeing some really starnge behavior with ListBoxs (Control
Toolbox) that are put on worksheets. I had a previous question posted last
Thursday about Listbox resizing that has not yet received a response.

Here is something else that is happening: with a listbox on a worksheet, I
go into print preview mode. When preview is closed, the listbox has moved
its position. This happens every time. I am currently dealing with this
in the worksheet activate event using code to move it back into position.
This is far from ideal since the user must deactivate and then reactivate
the sheet in order for it to work.

Anyone know why the listbox position may be changing and how to stop it? If
not, any suggestions on how to better deal with this behavior using code in
events to reposition it?

Thanks for your help. Using Excel 2002.

Keith Young