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.
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.