Results 1 to 4 of 4

Thread: vba forms in excel change their size by themselves?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular nardagus's Avatar
    Join Date
    Apr 2012
    Location
    PL
    Posts
    268
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default vba forms in excel change their size by themselves?

    Hello,

    I have created very simple form which has only one object: listbox.

    Strange thing happens. Mostly when I break code execution, but sometimes even a code runs to the end.
    Size of the form decreases. This self size change causes to autoadjust the listbox, but only its size. Not font size of the lb.
    When I manually increase the form size, listbox size also increases but only to the size it was set at the beginning.

    The same problem was when I created a form with couple of labels, text boxes and buttons.

    I'm not an expert with forms but I don't recall such problem using older versions of Excel. I didn't have this problem with Excel 2016. At least until some update...

    Any ideas?

    Nard
    Using Excel: 2007, 2010, 2013, 2016

    - be as much descriptive as you can. More info means faster solution and easier job for helpers.
    - when posting data samples use Forum Tools. Search for Forum Tools.
    - for vba code posting use [ code]Paste code here[/code ] tag
    - it would be nice to give your helpers a feedback if their solution actually worked
    - ...noone is perfect...


  2. #2
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,820
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: vba forms in excel change their size by themselves?

    When you say:
    Your quote:
    I have created very simple form

    Do you mean a UserForm?
    If not please explain what a Form is.

    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  3. #3
    Board Regular nardagus's Avatar
    Join Date
    Apr 2012
    Location
    PL
    Posts
    268
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: vba forms in excel change their size by themselves?

    Sorry. My bad. Yes. I meant UserForm.

  4. #4
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,820
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: vba forms in excel change their size by themselves?

    Would you please show us the code which when you run causes the UserForm to change size.
    What version of Excel are you using
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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