Amy DeLuca
New Member
- Joined
- Oct 18, 2002
- Messages
- 39
If the user types "Yes" in cell A1, I want a form to appear (frmFMB). If "No" then just the text to appear in the cell. Is this possible?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A" And UCase(Target) = "YES" Then frmFMB.Show
End Sub