I have a textbox that displays the value of a cell(E2), but the worksheet displays:
31 October 2006, yet the userform textbox value shows 10/31/06.
Is there a way i can change this to display as the sheet view (31 October 2006) ?


Corey....

Hi Corey,

Try:

'=============>>
Private Sub UserForm_Initialize()
Me.TextBox1.Value = _
Format(Range("E2").Value, "dd/mm/yy")
End Sub
'<<=============


---
Regards,
Norman



"Corey" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
I have a textbox that displays the value of a cell(E2), but the worksheet
displays:
31 October 2006, yet the userform textbox value shows 10/31/06.
Is there a way i can change this to display as the sheet view (31 October
2006) ?


Corey....

Hi Corey,

Or, more consistent with your indicated format:

'=============>>
Private Sub UserForm_Initialize()
Me.TextBox1.Value = _
Format(Range("E2").Value, "dd mmmm yyyy")
End Sub
'<<=============



---
Regards,
Norman

> Me.TextBox1.Value = _
> Format(Range("E2").Value, "dd/mmmm/yy")

This format returns the month as October!

Regards,
Stefi

„Norman Jonesâ€� ezt Ã*rta:

> Hi Corey,
>
> Try:
>
> '=============>>
> Private Sub UserForm_Initialize()
> Me.TextBox1.Value = _
> Format(Range("E2").Value, "dd/mm/yy")
> End Sub
> '<<=============
>
>
> ---
> Regards,
> Norman
>
>
>
> "Corey" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> I have a textbox that displays the value of a cell(E2), but the worksheet
> displays:
> 31 October 2006, yet the userform textbox value shows 10/31/06.
> Is there a way i can change this to display as the sheet view (31 October
> 2006) ?
>
>
> Corey....
>
>
>

TextBox1.Text = Format(TextBox1.Text,"d mmmm yyyy")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Corey" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
I have a textbox that displays the value of a cell(E2), but the worksheet
displays:
31 October 2006, yet the userform textbox value shows 10/31/06.
Is there a way i can change this to display as the sheet view (31 October
2006) ?


Corey....

Hi Steffi,

> This format returns the month as October!

Indeed! As does my last post!


---
Regards,
Norman

On Nov 7, 10:32 am, "Corey" <coreyt...@exemail.com.au> wrote:
> I have a textbox that displays the value of a cell(E2), but the worksheet displays:
> 31 October 2006, yet the userform textbox value shows 10/31/06.
> Is there a way i can change this to display as the sheet view (31 October 2006) ?

If your userform knows the address of the cell, or has a range that
points to it, then the .Text property should display the date as it is
seen in the worksheet...

Mike

Hi Mike,

> If your userform knows the address of the cell, or has a range that
> points to it, then the .Text property should display the date as it is
> seen in the worksheet...

I think that you will find that, without an intervening format instruction,
the textbox will speak with VBA's intrinsic American accent!


---
Regards,
Norman



"Mike Woodhouse" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
>
> On Nov 7, 10:32 am, "Corey" <coreyt...@exemail.com.au> wrote:
>> I have a textbox that displays the value of a cell(E2), but the worksheet
>> displays:
>> 31 October 2006, yet the userform textbox value shows 10/31/06.
>> Is there a way i can change this to display as the sheet view (31 October
>> 2006) ?
>
> If your userform knows the address of the cell, or has a range that
> points to it, then the .Text property should display the date as it is
> seen in the worksheet...
>
> Mike
>

Hi Mike,

I withdraw my comment with apologies!

Me.TextBox1.Text = Range("E2").Text

will display the worksheet's visual representation of the date,



---
Regards,
Norman

thanks for the reply Norman

I now can get 31/10/06 instead of 10/31/06,
But my aim is for "31 October 2006"

I tried changing the .value to .text but no go.
Any idea's

ctm
"Norman Jones" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Corey,
>
> Try:
>
> '=============>>
> Private Sub UserForm_Initialize()
> Me.TextBox1.Value = _
> Format(Range("E2").Value, "dd/mm/yy")
> End Sub
> '<<=============
>
>
> ---
> Regards,
> Norman
>
>
>
> "Corey" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> I have a textbox that displays the value of a cell(E2), but the worksheet
> displays:
> 31 October 2006, yet the userform textbox value shows 10/31/06.
> Is there a way i can change this to display as the sheet view (31 October
> 2006) ?
>
>
> Corey....
>