Solved

Excel:  How to get listboxes to not autosize

Posted on 2011-02-11
6
269 Views
Last Modified: 2012-06-27
Experts.  This a related question to a previous post.  I am having an issue with the auto sizing of my listboxes.  Every time I runa a macro to switch sheets, I notice that if I go back the list boxes have shrunk considerable.  In each sheet I had a auto zoom script but I have taken that out to troubleshoot.  Still even without it same issues arises.

Any thoughts? I would still like to have the auto zoom in the spreadsheet

This was the code for the opening of the page , then I added the code to the sheets (Modified)

Private Sub Workbook_Open()
    Range("A1:AD56").Select
    ActiveWindow.Zoom = True
    Range("D2:L3").Select
End Sub


Happy Friday!

 NOC-Reports-r10.xlsm
0
Comment
Question by:Maliki Hassani
  • 3
  • 2
6 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34870672
If they are activex listboxes, then they have a tendency to display that sort of behaviour, particularly when the window zoom is not 100%. Activex controls on worksheets are generally a bit buggy.
I would suggest that you use code to resize the controls in the activate event of the worksheet.
0
 

Author Comment

by:Maliki Hassani
ID: 34870686
Thanks Roya!  Let me see what I can do..
0
 
LVL 41

Expert Comment

by:dlmille
ID: 34872279
See Here:  http://www.blog.methodsinexcel.co.uk/2006/08/14/list-box-resizing-problems/

Click your right mouse on the listbox and set IntegralHeight to FALSE

Dave
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
ID: 34872318
The change is here.  I played with this for a while so I think its your solution, but try to make it break from here.

Dave
NOC-Reports-r11.xlsm
0
 

Author Comment

by:Maliki Hassani
ID: 34872371
Okay working on it now!
0
 

Author Comment

by:Maliki Hassani
ID: 34872419
Good to go!  works like a charm..  I have been working on another design.  I ran into a minor issue though..  Closing this one..  Thanks!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now