Date format textbox

G

Guest

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

Guest

You can write a OnUpdate routine using the following function

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TextBox will not clear date??????????? 4
Date format of a textbox 7
Textbox font colour change? 6
Textbox date format. 2
Date format in VBA 4
Textbox date formatting 14
Weird date format problem 2
TextBox Format 3

Top