Solved: Limit to 4 decimals in textbox using VBA

[nagavineela]

HI,
Thank you. I have data in excel and calculations were performed as below:
'Total Failure rate
Sheets("GroundFixed").Range("J" & i).Value = Sheets("GroundFixed").Range("H" & i).Value + Sheets("GroundFixed").Range("I" & i).Value
totfailrate = totfailrate + Sheets("GroundFixed").Range("J" & i).Value
txttotfailurerate.Value = totfailrate

Hence the above calculated value is populated in the text box "txttotfailurerate".

Please let me know if further clarification needed