View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dilettante dilettante is offline
external usenet poster
 
Posts: 25
Default 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