Worksheet_Change?
Hi,
Maybe this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub
If Target.Address = "$A$1" Then
If UCase(Target) = "ORANGES" Then
Application.EnableEvents = False
UserForm1.Show
Application.EnableEvents = True
End If
End If
End Sub
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"spreadsheetlady" wrote:
Hi,
I'm trying to automatically open a Form when a target cell contains an exact
text.
Example:
IF cell A1 says: "Oranges"
THEN
Open Form1.
I've only opened Forms using command buttons.
I was thinking maybe using Sub Worksheet_Change to do this?
If cell A1 says anything else, (false) Do not open Form1.
Thank-you in advance
Amy
|