Trigger Event for Range of Cells
Please refer to image of spreadsheet attached. I am trying to trigger an event when a value is placed a particular cell to the right of the "Membership Subscription" column if the value in the "Membership Subscription" column is not greater than zero (in other words that person has not paid his membership fee and so is not eligible to enter the event).
I have tried writing an Event code (see image 2) but cannot get past the basics (please refer to the second image). When I click on a worksheet cell in the range of interest I get a "Type Mismatch" error message.
The code is only meant to test the basic stage and then I hope to go on to achieve my objective of putting up an MsgBox message such as "Has not paid membership fee" if the "Membership Subscription" cell for that person in 0.00 (zero).
Any help with the basic problem, or indeed with the eventual solution would be appreciated.
Read responses in techsupportforum.com