Print the results of the combo box

[Hank Hendrix]

How can I get the compo box results to print - but not print the combo box
outline and down arrow? If I de-select "print" in the format control I
don't get anything printed.
I know I can put the combo box cell link, but I would like to leave the cell
link out and just not print the outline of the combo box.
Thanks
Hank

 

[Debra Dalgleish]

If these are combo boxes from the Control toolbox, you can do the following:

Switch to Design Mode (click the Design Mode button on
the Control toolbox)
Select the combo box, and click the Properties button
on the Control toolbox
Set ShowDropButtonWhen to 1-fmShowDropButtonWhenFocus
To hide the combobox borders, set SpecialEffect to 0-fmSpecialEffectFlat

Or, change the settings in the Workbook_BeforePrint event:

With Sheets("Sheet1").ComboBox1
.ShowDropButtonWhen = 0
.SpecialEffect = 0
End With