In my sheet T2 I have a value 1.0 which must show 1.0 but for the life of me I dont know how to format it with the userform inniatilize with a textbox when the form load to show correctly. In Cell T3 I have 6.7 but it doesnt show 6.7 -think it needs to be rounded too as it show 6.6 .Both must be rounded to the next decimal. Rep given for some help please
This is what I have at the form Initialize.....tried it but it also fails
Textbox2.Value =Application.Round(Val(Textbox2.Value) /Range ("T1") , 1)
Textbox1.Value =Application.Round(Val(Textbox1.Value) /Range ("T3") , 1)
Bookmarks