transfering data from VBA Userform to designated WorkSheet Table...

Hello,

I'm building a simple userform to fill out a certain table; in one of the textboxes i should input a date value "dd/mm/yyyy". The problem I've encountered is that in my table the date value is not recognized as being a DateFormat although the specific field is formatted as "ShortDate".
In other words: input date value "dd/mm/yyyy" (from userform) and I receive a text value in thet specific cell ref.

Thanks a lot

cast the value to a date before writing it to the Cell

for example if you want to write the Date from textbox mydate to cell A1 of the first sheet in your workbook use

Please Login or Register  to view this content.

You should make sure that the user has entered a Date else you will get an error

the date is entered from keyboard. Is there a proper way to enter the date? I used ( in the textbox) the format dd/mm/yyyy. if I were to type that in a cell I would automatically get it ShortDate formatted.

Thanks it went well. It was exactly what was missing.
Solved!