Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

combo box problem pleassee help me ===>

Posted by jj on June 28, 2000 11:29 PM

i have created a combo box. my problem is i just
want the data to be shown when i print it and not
the drop down list box. any ideas

Re: combo box problem pleassee help me ===>

Posted by David on June 29, 0100 1:11 AM

Use a different sheet for the data.
Try giving a little more info.

Re: combo box problem pleassee help me ===>

Posted by pjkl_1 on July 29, 0100 11:45 AM

Right click on comboBox, choose 'Format control', click on 'Properties' and uncheck box 'Print object'.

Now you can use the comboBox but it should noit be printed.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.