Growing ListBox Problem in Excel 2003
Posted on 2007-09-27
I have an Excel Listbox that I'm using on an Excel 2003 worksheet to change a cell (LinkedCell) which controls the conditional formatting in another part of the worksheet. The function works fine, but aesthetically it is fugley. Every time I go in and out of "Design Mode" in Excel the font size of the items in the listbox grow, matter of fact it appears that all elements of the listbox are growing until finally it is too big to see any of the listbox items. Any clues on how to stop this annoying and fugley behavior. I was hoping to develop this as a tool for end-customers to use, but with this behavior it won't work unless I can resolve this.