?
Solved

Growing ListBox Problem in Excel 2003

Posted on 2007-09-27
12
Medium Priority
?
340 Views
Last Modified: 2013-12-26
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.
0
Comment
Question by:ElftmannD
10 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 19975696
Is it possible to post a part of this worksheet which demonstrates your problem?
0
 
LVL 9

Expert Comment

by:antontolentino
ID: 19975852
try to explicitly define the text size in that control.

maybe it might help
0
 
LVL 45

Expert Comment

by:patrickab
ID: 19977357
Right click on the ListBox, select Properties and click on the Font line, set the Font and point size there.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 19977364
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
 

Author Comment

by:ElftmannD
ID: 19979694
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 19979764
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
 

Author Comment

by:ElftmannD
ID: 19980707
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
 

Author Comment

by:ElftmannD
ID: 19981650
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 19998167
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 20425171
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question