ComboBoxes

Nomis_Eswod

Board Regular
Joined
Jul 27, 2005
Messages
153
Hi,

I have a spreadsheet that has 4 comboboxes on it, from the control toolbox. Whenever I try and print the spreadsheet, these boxes dramatically shrink in size.

Any ideas why this might be? I do actually use a macro to print each worksheet, so that it can be done from 1 'control page'. To combat this, I was trying to build something into the print macro, like ComboBox1.Height = "19.5", but it didn't recognise the control.

Any other bright ideas on how to fix it?

Thanks!
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Nomis_Eswod

Board Regular
Joined
Jul 27, 2005
Messages
153
Looks like it could be! Did what it said and it printed ok!

I tried changing the properties the other way, thinking it might be the fact that it was over a cell causing it to print like that for the opposite reason, so I had it on don't move or resize!

Thanks for the help!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,821
Messages
5,574,515
Members
412,599
Latest member
Schu94
Top