#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default check box

Hello,
in sheet1 i will create button to print out data in sheet 1 but my

probelm some time i need 2 copy of print so need to make checkbox when

i check checkbox print 2 copy othrwise print 1 copy.

how it possible
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default check box

kalpesh

You have a lot of options. If you sometimes want to print 1 and sometimes want to print 2, you can have two buttons, the code for the second button would be something like

ActiveWindow.SelectedSheets.PrintOut Copies:=2

You could also, go with a single button option, but get the number of copies from a cell or an input. Or you could make a single click of the button print one copy and a double click print two copies. In that case the click code would be your current printing code, and the double click code would be the same, with the modification to have Copies:=2 at the end of the print line.

I hope this helps.

Ken


On Sunday, July 22, 2012 6:18:42 AM UTC-4, kalpesh wrote:
Hello,
in sheet1 i will create button to print out data in sheet 1 but my

probelm some time i need 2 copy of print so need to make checkbox when

i check checkbox print 2 copy othrwise print 1 copy.

how it possible


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
Copy and move check box (check boxes) with new cell link? Marty Excel Worksheet Functions 1 January 20th 10 08:43 PM
Loop through column(s) to check values, perform action based on check ward376 Excel Programming 4 November 6th 07 04:21 PM
Increase size of a Forms Check Box (click on to enter check mark) 718Satoshi Excel Discussion (Misc queries) 0 August 17th 07 01:52 AM
Check if Conditional Format is True or False / Check cell Color Kevin McCartney Excel Worksheet Functions 5 June 29th 07 11:12 AM
Enable check box in protected sheet + group check boxes Dexxterr Excel Discussion (Misc queries) 4 August 2nd 06 12:00 PM


All times are GMT +1. The time now is 09:28 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"