Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Varying page Excel report judypudy Excel Discussion (Misc queries) 6 July 13th 05 08:39 PM
select data and print in a new excel document hemi1 Excel Discussion (Misc queries) 2 July 7th 05 08:20 PM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"