How to stop form, if it has been already sent?

[tushar@excel]

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

[royUK]

Can you post the code that you have so far?

[tushar@excel]

Hi Roy,

Here is the code

Please Login or Register  to view this content.

The conditional variable are defined as Public and has been set true in module1.

Regards,
Tushar

[royUK]

Maybe this might work.

Please Login or Register  to view this content.