Format a textbox to show 1.0

[Excelnewbie001]

Hi everyone

Hope someone can help. How do I format a textbox to show 1.0 with 1 decimal point....It shows correctly in excel but not on a textbox that is linked to it. Thank you for any help with this

Textbox2.Value =Format(Val(Textbox2.Value) /Range ("T1") , 0.0))

 

[MickG]

Perhaps:-

          "0.0"

 

[Excelnewbie001]

Perhaps:-

          "0.0"

Thanks Mick -do this come under form innitialise since its a user form ? Thanx

 

[MickG]

Sorry , I meant as in :-

TextBox2.Value = Format(Val(TextBox2.Value) / Range("T1"), "0.0")

 

[Excelnewbie001]

Thank you will test and report back thank you Mick

 

[Excelnewbie001]

No joy not working