Don,
I am using a text box on a user form for the user to enter their date.
Could not figure out how to convert the date string to a serial number.
However the DateValue function does work as long as the cell in the
spreadsheet is formatted as numeric.

Thanks for the reply


"Don Guillett" wrote:



--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"VinceW" wrote in message
...
I have a text box where the user enters a date and it is assigned to
variable
txtDate. How to I convert that to the serial number of the date?

Thanks for the help

.