+ Reply to Thread
Results 1 to 6 of 6

Comboboxes change size

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    24

    Comboboxes change size

    Hi,

    I'm a fairly new user of Excel and VBA programming. In my work I am sometimes required to move around my laptop and use different secondary screens to showcase my work to coworkers. This seems to cause problems with the comboboxes and textboxes I use as input for my code, as they start to randomly change size and font size when I click them. Now recently I managed to accidentally save the file when the sizes were changed, and now they keep doing the same thing over and over at my own workstation, which is becoming quite infuriating.

    I have looked through the properties and format control of the boxes, and the size can be changed easily (though I'd prefer not having to do that every time I enter a value into them), but I haven't found a control for the font size inside the boxes. Is there any setting I can use to stop this annoying behavior, or are the objects themselves broken at this point so I need to recreate all of them? And also, how can I control the font size?

    Hoping someone is able to help =)

    Cheers!

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Comboboxes change size

    forms or activex controls? also is the window zoom set to 100% or a custom level?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    07-11-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Comboboxes change size

    I use the Control Toolbox to create them in Excel 2003, I believe that means ActiveX, but I'm not 100% sure. Window zoom is set to 100%. Does that help?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Comboboxes change size

    yes that means they're activex which are prone to this sort of behavior. can you use forms ones instead? they're more likely to work reliably. if not, I reckon you'll need code to resize them each time the workbook is used.

  5. #5
    Registered User
    Join Date
    07-11-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Comboboxes change size

    I see. I tried using the forms ones before, but they didn't seem to respond properly to my code (.AddItem and stuff like that gave me error messages). I might have done something wrong though, not sure. I guess I could write on-click subs to resize them everytime. The only the font size problem remains, do you know the command to change the font size? Also, thank you very much for helping out!

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Comboboxes change size

    sure
    Please Login or Register  to view this content.
    or you can do it in the properties window

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1