+ Reply to Thread
Results 1 to 10 of 10

Combobox size and list within keep shrinking

  1. #1
    Registered User
    Join Date
    02-09-2020
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    4

    Combobox size and list within keep shrinking

    Hi guys
    I'm not experienced in writing vba code. I have created an activex combobox to enable me to quickly move to another worksheet in my workbook. I have managed this mostly by following youtube videos lol!
    It works perfectly (surprisingly) BUT every time I click into the box the text within it shrinks and also the size of the box changes when I come back to the worksheet with it on.
    I am working in Excel 2010 on windows10 64bit.
    I have attached the file accordingly and the combobox in question says 'Go To Batch'
    I have googled the problem and searched on here to no avail so far and just wondered if someone could help me.
    Many thanks in advance
    Andy
    Attached Files Attached Files
    Last edited by andyk62; 02-09-2020 at 03:22 PM. Reason: didnt attach file

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Combobox size and list within keep shrinking

    A well known Excel bug, ActiveX controls are unstable on worksheets, has been there forever.
    Possible workaround would be to recreate the combobox everytime it is used.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Combobox size and list within keep shrinking

    Or you could use a Form Control rather than ActiveX, or even use an in cell drop down list (data validation) and a worksheet change event to fire the sheet change.

    BSB

  4. #4
    Registered User
    Join Date
    02-09-2020
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    4

    Re: Combobox size and list within keep shrinking

    Thx. Blimey who'd have thought MS would allow a glitch like that for so long!

  5. #5
    Registered User
    Join Date
    02-09-2020
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    4

    Re: Combobox size and list within keep shrinking

    Sounds interesting - could you point me to any 'how to' videos to do it like that by any chance?

  6. #6
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,410

    Re: Combobox size and list within keep shrinking

    While this does not answer your direct question, given what you want your code to do, I thought you might find this "Neat Go To Sheet Selector" that I posted a while ago in my mini-blog to be of some interest. You can find the code, a full description of its use and a demo file at the following link...

    A Neat "Go To Sheet" Selector

    One thing I did not mention in that blog article is that you can install all of the code to a workbook with blank sheets and then save it as a Template file. Then, when you are going to have a project with a lot of worksheets, you can open the Template file instead of a normal blank file and all the code will automatically be in place.
    Last edited by Rick Rothstein; 02-09-2020 at 03:41 PM.

  7. #7
    Registered User
    Join Date
    02-09-2020
    Location
    London, England
    MS-Off Ver
    Office 2010
    Posts
    4

    Re: Combobox size and list within keep shrinking

    That's brilliant Rick I'll look it over now

  8. #8
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Re: Combobox size and list within keep shrinking

    Hello

    i have the same problem, and found this thats worked, but can it be modfied so it takes all comboboxes or must i add a code for each

    Please Login or Register  to view this content.

  9. #9
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,410

    Re: Combobox size and list within keep shrinking

    Quote Originally Posted by andyk62 View Post
    That's brilliant Rick I'll look it over now
    Did you get a chance to try out my "Go To Sheet" selector yet? I am curious if it is something you can make use of or not.

  10. #10
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: Combobox size and list within keep shrinking

    If you are still experiencing ActiveX quirks the code in the module of the attached may be of assistance.


+ 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. Replies: 4
    Last Post: 08-07-2017, 02:49 PM
  2. [SOLVED] Help in shrinking Workbook Size
    By Unclerussty in forum Excel General
    Replies: 5
    Last Post: 10-26-2015, 06:54 AM
  3. Shrinking List through Data Validation
    By cLiffordiL in forum Excel General
    Replies: 2
    Last Post: 08-22-2014, 04:36 PM
  4. Shrinking text size-command button
    By chemi9 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 07:21 PM
  5. Shrinking Size of Excel File
    By Timothy100 in forum Excel General
    Replies: 5
    Last Post: 02-05-2011, 06:52 PM
  6. Shrinking list box
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2009, 11:58 AM
  7. Shrinking workbook size
    By emp1953 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2008, 09:39 AM

Tags for this Thread

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