VBA code for Special Characters?

[dinosaur1993]

What is the VBA code to check whether or not a value has a special character?
(aside from using Ascii Code)....

Cheers!
Dinosaur1993

[patel45]

can you attach a sample file with desired result ?

[dinosaur1993]

Its just like say for instance I have a textbox.

I will ask the user to enter a name (or any values without special characters (ie.~!@#$%^&*()). I want to check whether or not they have entered a string (and not a character) in the textbox

[HaHoBe]

Hi, dinosaur1993,

your question is as clear as mud:

Please Login or Register  to view this content.

Could you please explain to me how you would call each single part of a string?

You may use Len and Replace to find out if any special cahracters have been used (or InStr) or you may have a look at this function which might be of help:

Please Login or Register  to view this content.

Ciao,
Holger

[Leith Ross]

Hello dinosaur1993,

This is probably closer to what you are looking for. This is a Function that will test a single character or multiple characters. It returns True only for letters A to Z (upper case and lower case) and the Space character. Any other character or characters in the string will return a False.

Please Login or Register  to view this content.

[jindon]

This should do

Please Login or Register  to view this content.