excel vba - How to check whether data has 2 different types of data within it? -
excel vba - How to check whether data has 2 different types of data within it? -
i want take input checkbox, , check it, whether string having first 5 characters "mpost"
, next 8 characters numbers (between 00000000 99999999
), can please help me out on this?
the check "mpost" if left(variable,5) = "mpost" ...
check numbers if isnumeric(right(variable,8)) ....
excel-vba
Comments
Post a Comment