Hi,
I have following requirement.

Cell A Cell B

Do you want to change table (Y/N)

Do You want to change copybook (Y/N)


If for the first question answer is Y, I should throw a form, which I am able to by using Change event of worksheet and checking the value of Cell B.

When the second answer is also Y, I should send another form, but not the first one, in my case both the form are being sent and reason is obvious.

If User enters N for first and Y for second then only second form should be sent and vice versa.

And the form should be sent immediately after user enters the value.


I need a hint/code/ or anything which might help in stopping the form to be sent second time.


Regards,

Tushar