Link to home
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on

Excel VBA - If cell doesn't contain data

I would like to create a message box saying whether a particular cell contains a number or a word.

If active cell contains number then message box says "number"
If active cell contains alphanumeric then message box says "word"
If active cell contains a space then message box  says "spaces"
SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Lmao..You having some fun now..It's late gooo to sleep..let me make some points.. :-)

Saurabh...
Yes Saurabh. It's really late here 2:43 AM and it's late for you too.
Actually I was busy in a project and just going to log off now. :)
Yeah Buddy..I know..I'm in the same part of the Globe you are..And Me messing arround with power pivot as it's so complex thing i have built that every time i apply a filter ..im here coz it's going to take time to give me results.. :-)
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.