Thanks for getting back. Taking zooming out of the macro did help quite a
bit, or atleast made the list box behave differently. Changing the font
actually made things worse after zooming, even out of the macro. I more
confused that ever, and convinced that my lack of understanding, if not my
problems, are worse than I imagined. The basic problem really comes down to
the fact that I can't handle the List Box in continuously operating code. If
I run totally separate pieces of code, they work fine, when I run them
sequentially it fails. I will be posting a new more general question at the
top level in the next day or so.

Thanks

"Nile_Hef" wrote:

The control may have a 'Move and size with cells' attribute: this is set in
the 'Format Control' dialog, rather than the 'Properties' window, and it is
often overlooked when your fonts behave strangely.

Also, check the type of font - the dialog box displays a small icon beside
each one, with 'TT' representing TrueType fonts and a tourquoise ellipse (or
italic 'O') for OpenType. These fonts have sophisticated sizing and scaling
capabilities which, unfortunately, are not always supported fully by MSForms
controls on a spreadsheet.

Try using a font which has no such icon in the Fonts dialogue: this will be
a more primitive non-scaling font which will be more stable when displayed in
your listbox. It goes without saying that all such fonts are clunky, untidy,
and vile to look upon, but they are stable in controls that are subjected to
frequent resizing and the 'Zoom' action.

Start with 'MS Sans Serif', and take care not to confuse it with the
OpenType equivalent 'Microsoft Sans Serif'. In desperation (or if you want
that cyberpunk industrial archaeology experience) try using 'FixedSys'.