Date format of a textbox

  • Thread starter Thread starter Tdp
  • Start date Start date
T

Tdp

Help me please!!!
I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!!
I have a UserForm1 which in TextBox1 should display a date which it gets it
from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think
dd-mmm-yyyy")
Can anybody help?
 
What are you getting?
In formatting if you want the full month to display, you need 4 m's, not 3.
1m = the month number, i.e.: 7, 8, 9, 10,
2m = the month number, but always 2 digits, i.e: 07, 08, 09, 10
3m = abbreviated month, i.e.: Jul, Aug, Sep, Oct
4m = full month name
And if you want spaces, formatting would be: dd mmmm yyyy
 
Tdp said:
Help me please!!!
I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!!
I have a UserForm1 which in TextBox1 should display a date which it gets it
from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think
dd-mmm-yyyy")
Can anybody help?
Click to expand...
 

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 date format. 2
formatting of date 4
counting records by month and year / date format issues 1
Setting the date format 2
Date format textbox? 2
Date / Time problem 4
Extract the Month from a cell with a formatted date 3
Date Format 3

Back
Top