Using InpubBox to enter dates in two Excel cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a worksheet, which must remain protected out of the two cells where
the user has to enter two dates, with 5 sheets containing prices I compare
using a StartDate and a End Date.

There should be a button “Compareâ€
- starting a macro which opens a InputBox
- for the input of StartDate in the form as 25/05/1997
- and EndDate in the form as 25/09/1997,
- putting the dates respectively in the cells G3 and G4 of the sheet “Rates1â€

Should the date be written in wrong way a MsgBox should show the message
"Please use the form DD/MM/1997" (the year must be always this!!!)

Thank you for helping
 
This Post iwas sent incomplete.
Please have al ook to the next one:
How to enter dates in Excell cells using InputBox
Thank you
 
Back
Top