View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TimN TimN is offline
external usenet poster
 
Posts: 72
Default Date formatting in Excel VBA Text Box

Hi all,

I am new to VBA programming so forgive me for an elementary question, but I
can't seem to locate the answer.

I have created a User Form so that a date is entered then that date is
placed in a cell on the Excel spreadsheet. I want to format the Text Box to
only accept a valid date format such ad 01/10/06. How do I do that?

Thanks
TimN