List Box Problem
 

I am having a lot of problems with a List Box created from the Tools toolbox.
I want to install a multiselect list box into a newly created sheet. I
could not effectively make this work, so I ended up copying one that I
created on another sheet for that specific purpose.

I have a number of problems, but the most basic is that the font size
changes on the list box. Strangely enough, it does not change in the
properties. Any ideas of what I am doing wrong or not doing?

List Box Problem
 

If the font property stays the same but the appearance changes, there are
several possibilities.

1) You have the worksheet you copied the listbox from set to a differenct
ZOOM ratio than the worksheet you copied the listbox to.
2) The data you are viewing makes it appear as if the font size has
changed. For example, the data in the first worksheet was all capitals and
the data in the 2nd worksheet is all small letters.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"ZipCurs" wrote:

I am having a lot of problems with a List Box created from the Tools toolbox.
I want to install a multiselect list box into a newly created sheet. I
could not effectively make this work, so I ended up copying one that I
created on another sheet for that specific purpose.

I have a number of problems, but the most basic is that the font size
changes on the list box. Strangely enough, it does not change in the
properties. Any ideas of what I am doing wrong or not doing?

List Box Problem
 

Gary,

Thanks for your response,

The "Zoom" factor does not appear to be the culprit. I should note that I
am fixing the problem by changing the font size to 11 and then back to 10.
Even though it starts out at 10, this changes the size of the font.

"Gary L Brown" wrote:

If the font property stays the same but the appearance changes, there are
several possibilities.

1) You have the worksheet you copied the listbox from set to a differenct
ZOOM ratio than the worksheet you copied the listbox to.
2) The data you are viewing makes it appear as if the font size has
changed. For example, the data in the first worksheet was all capitals and
the data in the 2nd worksheet is all small letters.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"ZipCurs" wrote:

I am having a lot of problems with a List Box created from the Tools toolbox.
I want to install a multiselect list box into a newly created sheet. I
could not effectively make this work, so I ended up copying one that I
created on another sheet for that specific purpose.

I have a number of problems, but the most basic is that the font size
changes on the list box. Strangely enough, it does not change in the
properties. Any ideas of what I am doing wrong or not doing?

List Box Problem
 

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'.

List Box Problem
 

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'.