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.
you can test it using isnumeric before you write it to the cell
Josie
if at first you don't succeed try doing it the way your wife told you to
Thank you kindly. That worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks