Using InpubBox to enter dates in two Excel cells
 

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
--
dilettante

Using InpubBox to enter dates in two Excel cells
 

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


"dilettante" wrote:

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
--
dilettante