VBA code that calls a user form when a user enters a conditional date

[benhop]

<TABLE class=tborder id=post1862444 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_1862444 style="BORDER-RIGHT: #ffffff 1px solid">Hi all,

I'm trying to figure out how to call a user form when a user enters a date that falls in between two dates in two separate ranges within a single row. I'm thinking this might be VBA code in an If-Then type format, such as "If a cells value is greater than E4 and less than AN 4 then userform1.show." Of course, I'd like that translated through proper VBA coding. Can anyone help with this request? Thanks.

Benhop.
<!-- / message --></TD></TR><TR><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 1px solid">

</TD></TR></TBODY></TABLE>

 

[lenze]

Maybe a Change Event

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address <> "$A$2" Then Exit Sub
If Target > Range("$B$1") And Target < Range("$B$2") Then
   UserForm1.Show
End If
End Sub

lenze