Dynamic 'If" statement

[sbraun27]

Hello. I would consider myself intermediate at vba and almost completely self taught. Given this, I have found the answer to my question in other forums, but was not completely understanding of how to apply the solution to my specific issue.

I am attempting to basically say If "variable" = "other variable(1 to x)" then do "thing" else do "other thing" but am having issues pointing the if statement to the dynamic variable without using infinite 'or's.

My code is as follows:

Please Login or Register  to view this content.

If I can clarify anything, I would be more than happy to.

[TMS]

Untested but try:

Please Login or Register  to view this content.

[sbraun27]

Thanks Trevor, it worked perfectly. Could you maybe elaborate on the use of Option Explicit in your addition? Is it used for more than just forcing the declaration of variables?

[TMS]

You're welcome.


No, that's what it's for ... to force declaration of variables.




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.