calender in USER FORM and Calculation in

[mvpscm]

Hi All,

I have an EXCEL With one User form with 6 Updation USER FORMS which will be filled by different users in the department.

1) Export Invoice Details which is the First point of update in this the below are my queries.

a) I need Calendar to show in Export Invoice date.
b) Once after entering data of Invoice value and (FOB + Insurance ) in FOB FC the user form should automatically Subtract FOB +INSURANCE from invoice value and then show the value in FOB FC.

2) User form two SHIPPING BILL DETAILS ; When User selects the invoice Number , the form below data should go automatically to the particular row directly where the invoice number is.

3) before posting he should see what he is posting in PDF or in any form.

Regards,
MVP