how to apply multi functions to command bar.

[Asadpatel777]

I want to apply multi functions in command bar. i am fresher in excel and required codes to perform certain functions The functions to do with command button are as folllows.-

1. Task for Print and save invoice button should be, it should save invoice details like invoice no., date, amount of different taxes i.e. tax1, tax2 etc., final amount after taxes, to table in sheet2 Download Capture2.JPG from Sendspace.com - send big files the easy way

also the invoice should save in pdf and xlsx format in desired drive along with that, invoice should print simultaneously first. The screenshot of invoice is here for better understanding

Download Capture.JPG from Sendspace.com - send big files the easy way

I have tried using code for clear and new invoice which works perfectly but i need codes for print and save invoice button.

codes for clear and new invoice i tried

Private Sub CommandButton3_Click()Range("a10").Value = Range("a10").Value + 1
Cells(9, 5) = Date
Range("c12:d31") = ClearContents




End Sub

please help in provinding codes for print and save invoice button.

Kindly help.
thanx