Date format textbox

  • Thread starter Thread starter Guest
  • Start date Start date
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!!!!
 
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
Textbox font colour change? 6
Textbox date format. 2
Textbox date formatting 14
Date format in VBA 4
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Incrementing dates in the format MMM-YY 3
TextBox Format 3

Back
Top