MS Excel vba number formatting -

MS Excel vba number formatting -

is possible set format userform textbox automatically changes numbers 123456789.123456789 123,456,789.123456789.

private sub textbox1_change() textbox1.value = format(textbox1.value, "#,###.##") end sub

i used this, round number 123,456,789.12 .

is 123,456,789.123456789 possible within vba ? thanks.

you can add together many # want specify number of figures after dot. in case can utilize format

format(textbox1.value, "#,###.#########")

should work.

excel vba excel-vba