Check box to print and export

Hi,
this is a repost of my post here https://www.excelforum.com/excel-pro...tml?highlight=

I duno the title cannot end with Print. =(

hope someone can shine some light here. Refer attached. i need a macro where user can click on the checkbox (Column E which i put in Red fill). Then click either on Export button or Print button. Export button will CUT and Paste it to Export tab while if they click Print, it will print the voucher tab. The voucher tab currently is using vlookup to a cell in cell F1. So i hope that its possible if someone tick on S/N 1 and S/N 3 and Print, the macro shd "change the value in cell F1 to 1 n print, then repeat the process for 3"

Also, i hope to have a insert function where user can Add line (with the checkbox as well)

Thanks. Hope its not too demanding....=)

Hi, when i click export, i mean the line are cut and paste to export tab. Not delete entirerow.

Originally Posted by bakerman2

Remove this line.

Please Login or Register  to view this content.

Hi, but it didnt paste to the Export tab. How?

Hi, is there no way to do via Check Box?