Thread: input box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] RobcPettit@yahoo.co.uk[_2_] is offline
external usenet poster
 
Posts: 80
Default input box

Hi, Can you advise me how to use an input box for Dates only. Id like
the user to Input a date only as dd/mm/yyyy. If anything else entered,
or format wrong to tell user to try again. When date entered, to use
that information to search the workbook for the date, also to have a
msgbox apear to advise the month that has been entered. eg 20/09/2005 -
you have entered SEPTEMBER as your month. I hope this is not asking to
much.
Regards robert