I am wondering if there is a way to check the value of a variable against a list within my vba code. Sort of like using data validation, but instead of referencing a range on a worksheet, it would reference a list stored directly in my code. I envision something like: Dim List as integer Dim ChangingVariable as integer List = ( any of the numbers 1,2,3,4,5,6,7 or 8) ‘or whatever the code should be ' do some stuff that ends up with ChangingVariable = 3 If ChangingVariable = List then ' i.e. if the number is in the list ' do some stuff Else ' do some other stuff End If If this was SQL I would think of using the IN function, but as far as I can tell that doesn’t work in VBA. Thanks for the help!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

SQL IN function or Data validation in VBA

Thread starter cgclower
Start date Jun 8, 2010
Tags

data validation sql in

cgclower

New Member

Jun 8, 2010

I am wondering if there is a way to check the value of a variable against a list within my vba code. Sort of like using data validation, but instead of referencing a range on a worksheet, it would reference a list stored directly in my code. I envision something like:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com