Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Manchester, England

    Unanswered: Controls- weird behaviour!

    Hi All,

    I'm using Excel 2003. When I use controls from the control toolbox on a worksheet the text inside appears slightly compressed and distorted- until you click on them that is- then they appear fine. When they lose the focus they shrink back by a pixel and the text looks distorted again. I can't find any settings or properties relating to this. I also use Excel 2000 and there is no problem. Has anyone else experienced this behaviour? Any help greatly appreciated as always.


  2. #2
    Join Date
    Dec 2003
    Ottawa, Canada

    Controls and Zoom


    If your sheet is zoomed out (75%) the text in a VBA text box is warped and there is nothing to do about it.

    I only use controls on userforms. They were created for that purpose because in most programs you cannot just enter a value in a cell.

    So use cells instead of controls. If you want a drop down list see the much easier way to do it with "Data/Validation" at:
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts