+ Reply to Thread
Results 1 to 4 of 4

ActiveX combobox in spreadsheet re-sizes each time the macro runs

  1. #1
    Forum Contributor
    Join Date
    08-16-2010
    Location
    Holland, MI
    MS-Off Ver
    Excel 2007
    Posts
    110

    ActiveX combobox in spreadsheet re-sizes each time the macro runs

    Hi all,
    I have a combobox embedded in a spreadsheet that runs a macro each time the value is changed. Each time I change it, after the macro is run, the size of the combobox drop arrow and the text inside it is changed, it literally gets smaller as shown on my screen. When I go into the properties of the combobox, the font size is unchanged. Can anyone help me figure out what is wrong? I'm attaching the file so you can see it.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,218

    Re: ActiveX combobox in spreadsheet re-sizes each time the macro runs

    Use Forms controls on your worksheet rather than Active X, they are much more stable

  3. #3
    Forum Contributor
    Join Date
    08-16-2010
    Location
    Holland, MI
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: ActiveX combobox in spreadsheet re-sizes each time the macro runs

    Thanks for the advice. I played with that but was unable to figure out how to run the macro based on the value that was selected from the form control. With ActiveX, I knew it was Combobox1.value. Not sure how to get that value from a form control combobox. Any tips on how to do that?

  4. #4
    Forum Contributor
    Join Date
    08-16-2010
    Location
    Holland, MI
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: ActiveX combobox in spreadsheet re-sizes each time the macro runs

    And, can I run a macro when the combobox value is changed like I can with the ActiveX combobox?

+ 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: 2
    Last Post: 10-19-2012, 10:16 AM
  2. [SOLVED] Run-time Error '91 ' ActiveX combobox
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-15-2012, 07:27 AM
  3. ActiveX ComboBox on Spreadsheet
    By DM2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-12-2010, 06:28 PM
  4. Macro Runs fine in debug but not from ComboBox
    By jaslake in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-25-2009, 10:17 AM
  5. [SOLVED] Run macro but let user update spreadsheet while it runs
    By Ev in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2005, 03:05 PM

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