Number format of textbox in userform
 

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

Number format of textbox in userform
 

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

Number format of textbox in userform
 

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

Number format of textbox in userform
 

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