Previewing a form combo box

[Guest]

I am creating a form combo box in a worksheet in excel 2003, when I try to
preview the combo box with the print object checked, it previews and prints
the drop down box. When the print object is unchecked, nothing prints. How
do I get the item I choose to print w/o the drop down box?

 

[BrianB]

It may be that the combobox has focus (is selected) when you print. Tr
putting a line of code before you print


Code