Coding assistance for TextBox Vlookup rounding to 2 decimals

**sintek** · 08-07-2016, 01:55 PM

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.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

etc etc etc

**protonLeah** · 08-07-2016, 02:46 PM

Please Login or Register  to view this content.

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

**sintek** · 08-07-2016, 02:52 PM

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

Thanks protonLeah

Re: Coding assistance for TextBox Vlookup rounding to 2 decimals