Thank you very much Kevin, just the job it works great
--
George


"Kevin B" wrote:

You can write a OnUpdate routine using the following function

TextBox1.value = format(TextBox1.Value, "dd-mmm-yy")


--
Kevin Backmann


"George" wrote:

I'm trying to format a textbox (in a userform) so that what ever date I write
it shows and places it in a cell as "dd-mmm-yy".
I'v tried different ways with no luck.
Please help!!!!
--
George