Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » List Box

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

List Box

Resolved · High Priority · Version 2003

Reply Tue 23 Mar 2010, 09:42Delegate Trevor said...

Trevor has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access Intermediate course
Excel VBA Advanced course

List Box

Morning

Could you possibly tell me how I stop a List Box from changing its shape (by itself) when a view is toggled between Full Screen and Normal View.

Thanks

Trevor Clements

For upcoming training course dates see: Pricing & availability

Reply Thu 25 Mar 2010, 16:45Trainer Anthony said...

RE: List Box

Hi Trevor, thanks for your query. Can you give me a bit more information. What application are we talking about, and is the List Box on a form or bolted onto a spreadsheet?

Hope this helps,

Anthony

Reply Fri 26 Mar 2010, 11:24Delegate Trevor said...

RE: List Box

It is just a simple Embeded List box Form control using a named range as the contents. It was not created through VBA

It just resets itself when toggling between Full and Normal Screen.

I am sure it something to do with one of the properties

Thanks

Trevor

Reply Fri 26 Mar 2010, 18:54Trainer Anthony said...

RE: List Box

Hi Trevor. Try right-clicking on the listbox, go to Properties and change IntegralHeight to False. See if that helps.

Anthony

Fri 2 Apr 2010: Automatically marked as resolved.

Excel articles

· How To Disguise Error Messages In Excel 2007/2010
· Microsoft Excel Training - Numerical excellence for all
· Create Contrasting Coloured Rows In Excel
· Excel 2010 - Is It Worth The Upgrade?
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?

Please browse our web site to find out more about
financial excel course london and other Microsoft training courses.

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips