Avatar of cincimike
Flag for United States of America

asked on 

Excel - validate text in the list (" abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789")

Hi Folks -

I am looking for a way to validate text strings against just this list of values: " abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789". Any characters outside of this list would indicate unwanted characters, either by raising an error or somehow indicating unwanted characters such as : (&,%,$,-,!) and so on.

I seek to create a method for end users to replicate the validation in Excel that I have created in Oracle and MS-Access.

Any thoughts about how to approach this challenge?

Thanking all of you in advance,

Microsoft ExcelVBA

Avatar of undefined
Last Comment

8/22/2022 - Mon