Data Entry Validation [Excel 14/2010 (VBA Only)]

I have the following section of code in a userform. I want to validate the data prior to it being written into the spreadsheet. For example, when testing I accidently typed 248..85. The Ccur(x) line then had a Type 13 mismatch error as currency does not have a double decimal point.

Please Login or Register  to view this content.

Thank you kindly. That worked perfectly.