View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
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