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.

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.

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

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