Hi All

Please help. I am trying to force my TextBox to show a value to 2 decimals with no luck. Have tried all possibilities.

TextBox3 = Application.WorksheetFunction.VLookup(TextBox1.Text, Format(Sheet2.Range("B2:O25"), 5, False), "0.00")
or
TextBox3 = Application.WorksheetFunction.VLookup(TextBox1.Text, Format(Sheet2.Range("B2:O25"), 5, "0.00", False))
etc etc etc