Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • 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
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.

 
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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