check box

[kalpesh]

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

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

i check checkbox print 2 copy othrwise print 1 copy

how it possible

 

[KenCowen]

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 clickcode 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