View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RustyOnVBA RustyOnVBA is offline
external usenet poster
 
Posts: 5
Default Validation on InputBox()

Is there any way to ensure that a user inputs a valid dd/mm/yyyy date into an
input box, the current code is DateInput = InputBox("Please input date ")

Also the ideal the ideal solution would be to use the calendar function but
for the life of me i cannot remember for the life of me what to call for this.

I would also like to know validation on inputboxes in general but thats less
time critical at the moment

Any help would be greatly appreciated