Previewing a form combo box
 

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?

Previewing a form combo box
 

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


Code
-------------------
Activesheet.Range("A1").Select
-------------------


--
Message posted from http://www.ExcelForum.com