+ Reply to Thread
Results 1 to 4 of 4

Increase ComboBox width only while active

  1. #1
    Registered User
    Join Date
    06-17-2020
    Location
    Seattle, WA
    MS-Off Ver
    365
    Posts
    4

    Increase ComboBox width only while active

    I'd like to increase the size of the combobox temporarily to be able to view more of the choice the user is seeing. I tried to copy and paste script that I found on the net but I don't know what I need to change for it to work on my spreadsheet. Any help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,516

    Re: Increase ComboBox width only while active

    If what you asked for can even be done, the amount of code to make it work in Excel would be large. But I have a question... why not just make the ComboBoxes and the column they are in wider? I mean, you have more than enough room to expand them and doing so would allow all the text that is chosen to be displayed.

  3. #3
    Registered User
    Join Date
    06-17-2020
    Location
    Seattle, WA
    MS-Off Ver
    365
    Posts
    4

    Re: Increase ComboBox width only while active

    I am trying to keep the size that I have so that if the page is printed it will fit on just one page.

  4. #4
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,858

    Re: Increase ComboBox width only while active

    Hi jrod68,

    Try removing the 'ActiveX' ComboBoxes and replacing them with 'Data Validation'. Since you already have 'Merged Cells' in columns 'G' thru 'O', use VBA to increase/decrease the width of Column 'O' as required.

    When you print, print using VBA so you can make sure the width of Column 'O' is correct.

    Lewis

+ 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: 3
    Last Post: 06-08-2018, 11:42 AM
  2. [SOLVED] Increase size of bar width within chart area
    By drinkmorewine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2013, 03:44 PM
  3. Replies: 2
    Last Post: 04-23-2011, 10:28 AM
  4. How to increase the Width of the Task Pane (2003 & 2007)?
    By Green in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2006, 04:00 AM
  5. Increase width of chart column
    By Gemini in forum Excel General
    Replies: 2
    Last Post: 04-11-2006, 08:10 AM
  6. [SOLVED] increase column width in PowerPoint chart
    By PowerPoint Question in forum Excel General
    Replies: 0
    Last Post: 02-22-2006, 06:10 PM
  7. Increase width of cell names in formula bar
    By Dan Reichel in forum Excel General
    Replies: 1
    Last Post: 05-31-2005, 04: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