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

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("L:L")) Is Nothing Then
    If FirstTimeTableForm Then
       
     If UCase(Cells(11, 12)) = "Y" Then
        TABLES.Show
        FirstTimeTableForm = False
     End If
    End If
    If FirstTimeCopybookForm Then
       If UCase(Cells(18, 12)) = "Y" Then
        Copybook.Show
        FirstTimeCopybookForm = False
        End If
    End If
End If
End Sub

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

Regards,
Tushar

[royUK]

Maybe this might work.

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("L:L")) Is Nothing Then
        If FirstTimeTableForm Then

            If UCase(Cells(11, 12)) = "Y" Then
                TABLES.Show
                FirstTimeTableForm = False
                Exit Sub
            End If
        End If
        If FirstTimeCopybookForm Then
            If UCase(Cells(18, 12)) = "Y" Then
                Copybook.Show
                FirstTimeCopybookForm = False
                Exit Sub
            End If
        End If
    End If
End Sub