Macro Coding calculating if one date entry is before another date entry

M

macroapa

I have two date fields within a User Form.

I require code that will amend produce two different sets of wording
dependant on whether Date A is before or after Date B.
ie If Date A is before Date B then Type "xxxxxx"
If Date A is after Date B then Type "yyyyy"
 
J

Jezebel

Date variables are just doubles in drag, so you can use ordinary arithmetic
to compare them --

If DateA < DateB then ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top