test string from textbox for alpha or numeric characters
Posted on 2014-10-07
what i need:
I have a variable assigned to a userform textbox
cD = Userform2.Textbox37.text
The textbox is being filled from an activecell.value on the sheet
I need to check cD to test whether or not it contains alpha or numeric characters..
I'm picking up what appears to be " " FROM THE Sheet cell, but cant capture what it is...so trying to determine what it is NOT ?
I have tried ISEMPTY
IF cD = " "
none of these work ?