vb textbox date

[bearbubble]

when entering a date from a textbox in a excel vb userform
the date get turned around (dd mm yy entered but mm dd yy ends up in the cell
how can i stop this

thanks

mick

 

[blue9244]

You need to format the date. If entering in Excel, just format the cell to the output you want. If formatting from vba use:

.Numberformat = "dd mm yy"

Hope this helps...

Sue...

 

[bearbubble]

when entering a date from a textbox in a excel vb userform
the date get turned around (dd mm yy entered but mm dd yy ends up in the cell)
the cell format is set for dd mm yy
how can i stop this

 

[sdiverdan]

I cannot find a date using "Find" in excel. I have dates in the first column in format "mm/dd/yyyy" and need to find the row the date is in. I'm using the following lines and the result is the date is not found. I tried using the 11/12/2003 as a number, a string,as a variable and even as the number 37937 however its not found. If I search on a number or string in a different column the code works.

With Worksheets(Sheet1).Range("a1:a100&quot
Set c = .Find("11/12/2003&quot 'find first occurrence

Please help

Dan

 

[sdiverdan]

Sorry this should have been a new post. Couldn't figure out how to delete it once it was posted.

Dan