Coding assistance for TextBox Vlookup rounding to 2 decimals

[Sintek]

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

[protonLeah]

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

We don't know if the values in Sheet2.Range("B2:O25") are text strings or numeric...

[Sintek]

Of course....Silly me. Been at it all day. Blinkers lol.

Thanks protonLeah