debug error with CDate function in empty textbox

[ohexcell_ineedu]

Hey guys,

I am trying to create a form that the user keys in the date in the format dd/mm/yyyy, and it then gets pasted into a cell. Sometimes though there isn't always a need to fill in the textbox with a date, and that produces an error (because there are no values there that are a date).

You can download my sample worksheet from here - https://dl.dropboxusercontent.com/u/9154762/Book1.xlsm

Just open up the user form then don't key in any values to repeat the error.

Any help will be appreciated.

 

[RoryA]

Just test the textbox first:

If IsDate(Textbox.text) then activecell.value = CDate(textbox.text)

for example.

 

[ohexcell_ineedu]

cheers rory. worked like a charm!

 

[RoryA]

Glad to help.