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

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -