Good Day All,

I am new to this Excel VBA but I'm loving what I've seen so far.

I have created an Excel Form that has two text fields, one timebox field and one button to print.

The print button currently updates the time in the timebox field when clicked, and prints out two copies of the form on my default printer.

I want to be able to assign another function to this button after it prints out the form. I want to copy the data from both the text fields and the timebox field onto a worksheet in respective columns.

So throughout the day when I enter text and press the print button it must copy data to new lines each time.

At the end of the day I want another button (SAVE) to be able to print the data in the sheets to my CutePDF printer, and save the file in the format YYYYMMDD.xlsx

I've attached my current code

TEST.xlsm

Anyone care to help me out ?

Regards

Azhar