Growing ListBox Problem in Excel 2003

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.
ElftmannDAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
Saqib Husain, SyedEngineerCommented:
Is it possible to post a part of this worksheet which demonstrates your problem?
0
 
antontolentinoCommented:
try to explicitly define the text size in that control.

maybe it might help
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
patrickabCommented:
Right click on the ListBox, select Properties and click on the Font line, set the Font and point size there.
0
 
Rory ArchibaldCommented:
If you are using controls from the Control Toolbox, try replacing them with controls from the Forms toolbar. These are much more stable when used in a worksheet. ALternatively, you might want to  look at using Data Validation to create an in-cell dropdown instead.
Regards,
Rory
0
 
ElftmannDAuthor Commented:
For a List box from the Forms toolbar, I cannot change the font size to 72 pt in the list items.  Because I need to be zoomed to 16% based on the required viewable area, I need the list box text to be this large for the user to be able to determine the item to be selected.  I agree that the Forms toolbar widgets are much more stable, and I utilize them whenever possible.  I'm not sure I understand the comment about using Data Validation, but I will research it.
0
 
Rory ArchibaldCommented:
You can use Data Validation to create a drop-down list in a cell. It's not quite the same as a list box, but should be a lot more stable.
0
 
ElftmannDAuthor Commented:
This is a good suggestion, but because the zoom is at 16% and the items in the validation list don't appear to scale, they cannot be seen at 16%.  It is unfortunate that the ListBox from the Control Toolbox is so unstable.  Is this something that is just an accepted fact?  Are there any other options to get a Listbox with a large font in a stable control element.
0
 
ElftmannDAuthor Commented:
I chose from the Control Tool Box toolbar the "more controls" Microsoft Forms 2.0 ListBox and this one appears to be behaving stably.  No growing with each selection of an item from the list...I think I'm done
0
 
Rory ArchibaldCommented:
Since you solved your own problem, you should post a question in Community Support with a link to this one, asking for this to be PAQd and your points refunded.
Regards,
Rory
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.