none
ActiveX Control - Command button and listbox auto resize RRS feed

  • Question

  • Hi all Gurus,

    I have a problem regarding the ActiveX Control - Command button and listbox. I built a form in Excel 2010 and it looks fine, but the command button and listbox will be auto resized in following circumstances:

    1. When the laptop connecting to a projector

    2. When the file is opened by office 2007

    Do you have any clues of the cause and any solutions?

    thanks,

    Tuesday, April 28, 2015 3:18 AM

All replies

  • Is this a Userform that you created or you created a form on a worksheet?

    If on a worksheet, then the resizing of controls is a known problem if the Zoom is not set to 100%.

    Alternatively you can use VBA code in the worksheet's Activate event to resize all controls to the required size. I have previously used a hidden worksheet to store the position based on the TopLeftCell plus the height and width.


    Regards, OssieMac


    Tuesday, April 28, 2015 3:38 AM
  • Hi johnchenqiang,

    Do you set the AutoSize property of these control to false?

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, April 29, 2015 6:39 AM
    Moderator