Hi!

I am having difficulty with an ActiveX listbox on a worksheet and differing
screen resolutions. The listbox keeps changing sizes depending on the screen
resolution.

For example, I created a new workbook while in 1440x900 mode, added a
listbox control, and saved the workbook and closed Excel. Next, I changed to
1920x1200 and reopened the workbook. Now, clicking in and out of "Design
Mode" causes the font size in the box to continually get bigger until all
that is left is a black box where the listbox was. Next, I saved the
workbook, changed back to 1440x900, and reopened the workbook. The listbox
was so small it wasn't even visible. I had to go into design mode and click
around until the handles appeared, then I could drag the box out to a decent
size.

Is there any way I can "pin" the control to a range of cells, so the the box
coveers those cells, regardless of the display resolution?