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