• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

Excel: How to get listboxes to not autosize

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
Maliki Hassani
Asked:
Maliki Hassani
  • 3
  • 2
1 Solution
 
Rory ArchibaldCommented:
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
 
Maliki HassaniAuthor Commented:
Thanks Roya!  Let me see what I can do..
0
 
dlmilleCommented:
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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
dlmilleCommented:
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
 
Maliki HassaniAuthor Commented:
Okay working on it now!
0
 
Maliki HassaniAuthor Commented:
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now