Hello!

I have a userform with textboxes showing financials per month. My goal is to
show the number format "#,##0.00# for
- first entries in that textbox
- values already available in my sheet.

Currently I am using this code for the textbox

Private Sub txt_janEUR_AfterUpdate()
txt_julEUR.Text = Format(txt_julEUR.Text, "#,##0.00")
End Sub

This helps to return the format after data entry.
Now I am missing code to show the same format for data that exists already
in the table. The number format in the table is proper ("#,##0.00") but the
number in the textbox is shown without this format.

I hope there is a solution for this.

Kind regards,

Bodo Frost

Use the same line of code when you first show the UserForm.
__________________________________________________ ____________________

"Bikash" wrote in message
...
Hello!

I have a userform with textboxes showing financials per month. My goal is
to
show the number format "#,##0.00# for
- first entries in that textbox
- values already available in my sheet.

Currently I am using this code for the textbox

Private Sub txt_janEUR_AfterUpdate()
txt_julEUR.Text = Format(txt_julEUR.Text, "#,##0.00")
End Sub

This helps to return the format after data entry.
Now I am missing code to show the same format for data that exists already
in the table. The number format in the table is proper ("#,##0.00") but
the
number in the textbox is shown without this format.

I hope there is a solution for this.

Kind regards,

Bodo Frost

It is always the same textbox. Where do I put this code then?

Regards,
Bodo

"Vasant Nanavati" wrote:

Use the same line of code when you first show the UserForm.
__________________________________________________ ____________________

"Bikash" wrote in message
...
Hello!

I have a userform with textboxes showing financials per month. My goal is
to
show the number format "#,##0.00# for
- first entries in that textbox
- values already available in my sheet.

Currently I am using this code for the textbox

Private Sub txt_janEUR_AfterUpdate()
txt_julEUR.Text = Format(txt_julEUR.Text, "#,##0.00")
End Sub

This helps to return the format after data entry.
Now I am missing code to show the same format for data that exists already
in the table. The number format in the table is proper ("#,##0.00") but
the
number in the textbox is shown without this format.

I hope there is a solution for this.

Kind regards,

Bodo Frost

There must be some code which first "shows" the UserForm. Put the line of
code right after that.
__________________________________________________ ______________________


"Bikash" wrote in message
...
It is always the same textbox. Where do I put this code then?

Regards,
Bodo

"Vasant Nanavati" wrote:

Use the same line of code when you first show the UserForm.
__________________________________________________ ____________________

"Bikash" wrote in message
...
Hello!

I have a userform with textboxes showing financials per month. My goal
is
to
show the number format "#,##0.00# for
- first entries in that textbox
- values already available in my sheet.

Currently I am using this code for the textbox

Private Sub txt_janEUR_AfterUpdate()
txt_julEUR.Text = Format(txt_julEUR.Text, "#,##0.00")
End Sub

This helps to return the format after data entry.
Now I am missing code to show the same format for data that exists
already
in the table. The number format in the table is proper ("#,##0.00") but
the
number in the textbox is shown without this format.

I hope there is a solution for this.

Kind regards,

Bodo Frost