| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VBE, how can I set a date format different than the system date
I have a date format stored in a string and want to format a date in a text
box on a userform the same as my DateFormatString. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VBE, how can I set a date format different than the system date
TextBox1.Text = Format(TextBox1.Text, DateFormatString)
-- HTH Bob "Alpineskier" wrote in message ... I have a date format stored in a string and want to format a date in a text box on a userform the same as my DateFormatString. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VBE, how can I set a date format different than the system date
Hi,
Try this Dim MyString As String MyString = "yyyy/mm/dd" TextBox1.Text = Format(Date, MyString) or for another date Mydate = #3/11/2000# Dim MyString As String MyString = "dd mmmm yyyy" TextBox1.Text = Format(Mydate, MyString) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Alpineskier" wrote: I have a date format stored in a string and want to format a date in a text box on a userform the same as my DateFormatString. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieving short system date format in VBA | Excel Programming | |||
| Convert military date system to standard date system | Excel Discussion (Misc queries) | |||
| Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
| HOW DO I FORMAT A CELL IN EXCEL TO PICK CURRENT SYSTEM DATE | Excel Programming | |||
| Getting the Date Format Being Used By The Operating System And Exc | Excel Programming | |||
Linear Mode
