ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print only selected data from ComboBox? (https://www.excelbanter.com/excel-discussion-misc-queries/99324-print-only-selected-data-combobox.html)

yangjay

Print only selected data from ComboBox?
 
Hi,

I've created a combobox (drop-down box) and when I print, I only want
the data selected to appear. So far, I've only been able to print with
all of the box including the arrow (which I don't want) and unchecking
"Print Object" will print nothing. Any help/suggestions would greatly
be appreciated. Thanks.


Dave Peterson

Print only selected data from ComboBox?
 
Maybe you could use a linked cell with that combobox (from the Control toolbox
toolbar). Put the linked cell right under the combobox and choose not to print
the combobox itself.

yangjay wrote:

Hi,

I've created a combobox (drop-down box) and when I print, I only want
the data selected to appear. So far, I've only been able to print with
all of the box including the arrow (which I don't want) and unchecking
"Print Object" will print nothing. Any help/suggestions would greatly
be appreciated. Thanks.


--

Dave Peterson


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com