Date format textbox

G

George

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!!!!
 
K

Kevin B

You can write a OnUpdate routine using the following function

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