+ Reply to Thread
Results 1 to 5 of 5

ComboBoxes and ListBoxes Resizing on Their Own

  1. #1
    Registered User
    Join Date
    12-11-2013
    Location
    Emeryville, USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    ComboBoxes and ListBoxes Resizing on Their Own

    I have written a Macro that requires two comboboxes and a list box. After running the code and going to the sheet the boxes are located on, everything seems fine. The problem arises when I leave the sheet and go to another sheet then return to the sheet with the boxes. The start doing weird things. The text gets super tiny, or the boxes get huge. It seeems very capricious, as it seems to happen almost randomly. Here is the code I used for the combobox:


    Please Login or Register  to view this content.
    Here is the code for the listbox, which is very similar:

    Please Login or Register  to view this content.
    Has anyone else encountered this sort of thing? I have no idea what in the code is making those boxes do that. Any suggestions or idea would be greatly appreciated.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: ComboBoxes and ListBoxes Resizing on Their Own

    Are any of cells being resized? Are the properties of the objects set to resize based on cells?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: ComboBoxes and ListBoxes Resizing on Their Own

    This is common problem with ActiveX control on worksheets. You may add code to resize the controls or you may try with Forms controls.

  4. #4
    Registered User
    Join Date
    12-11-2013
    Location
    Emeryville, USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: ComboBoxes and ListBoxes Resizing on Their Own

    Quote Originally Posted by Solus Rankin View Post
    Are any of cells being resized? Are the properties of the objects set to resize based on cells?
    No, not that Im aware of. Do you know where I would look to check if that's what's going on?

  5. #5
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: ComboBoxes and ListBoxes Resizing on Their Own

    Right click and go to properties (ActiveX) or right click and go to Format control -> Properties tab (Form Control).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change comboboxes to listboxes
    By Jcanguy in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-01-2010, 12:30 AM
  2. Removing Duplicates in Listboxes or Comboboxes
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-02-2010, 08:32 AM
  3. [SOLVED] Resizing cells in a selection without resizing entire sheet
    By Danielle via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 08-11-2006, 05:10 PM
  4. [SOLVED] listboxes
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2005, 12:06 PM
  5. listboxes
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2005, 07:06 AM

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