Hi Everybody,

I need a form that will pop up automatically when a workbook is opened. The form should be able to do the following:

1. Allow input for cells B1, B2 and B3 in Sheet1 under the descriptions "Name", "Number" and "Date."

2. The form then will ask: "Print Packet?"

.......If "YES" then it should print Sheet4 of the workbook to the local default printer.
.......If "NO", it should leave the workbook open and make Sheet1 the Active Sheet.
.......In either case it should copy the data from the three text form fields fields into cells B1, B2, and B3 and close the form.

The form does not have to clear since it is only to be used once. It would be nice if it only pops up when B1, B2 and B3 are empty.

Can anybody help? Thanks in advance.