There were a couple of issues that you need to watch for.
- When using the worksheet change event, you should toggle enable events
- If you are going to reference a range like C9 then you have to explicitly call it as a range:
![]()
If Range("C9") = "X" then...
Bookmarks