Call method based on cell change/value

[j.lancaster1]

Hello,

I am attempting to have my macro run anytime the value of B1 changes. If B1 = 1, I want to run (just for example) Sub x, if B1 = 2, run Sub y, if B1 = 3, run Sub z. Here's my code so far, which does not include the B1 value at all, just if B1 changes, run macro. I'm a noob at this, but I think I'm looking for an "And" clause to add on to each of my If statements.

Please Login or Register  to view this content.

Any help would be appreciated

[Leith Ross]

Hello j.lancaster1,

The Select Case statement makes doing this much easier.

Please Login or Register  to view this content.

[j.lancaster1]

Wow, that makes much more sense. Thank you!

[Leith Ross]

Hello j.lancaster1,

You're welcome.