Hi

I was wondering if someone could help me with the below.

I want to create a macro where when I open my spreadsheet an Input Box appears saying: "Enter Trade Date" This should be entered as DD/MM/YYYY format.

I then want to paste the answer into cells C2:C1500

Upon this being completed I want another Input box to appear saying "Enter Settlement Date" Again this should be entered as DD/MM/YYYY format.

I then want to paste this value into cells E2:E1500


Can anyone help?

Thanks

McCrimmon