Call method based on cell change/value

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

Hello j.lancaster1,

The Select Case statement makes doing this much easier.

Please Login or Register  to view this content.

Hello j.lancaster1,

You're welcome.