kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Hello world,
I am here again with yet another challenge (from my end) and I need someone to help me out with the best way to get it resolved.
I have a textbox which contains date in the format "dd-mm-yy".
Now I want to set date ranges say "11-06" to "28-06" ( 11th June to 28th June) for example so that if I enter say "20-06-21" (20th June 2021) into my textbox, it should display matched on my MsgBox alert.
I will be using multiple date ranges (maybe 5 or more) and I want to check all those ranges for the match.
If it matches in the first range, display "match 1"
In the second, "match 2" and so on.
I don't know how to do it. I will be glad if someone can pull it up for me.
Thanks in advance.
Kelly
I am here again with yet another challenge (from my end) and I need someone to help me out with the best way to get it resolved.
I have a textbox which contains date in the format "dd-mm-yy".
Now I want to set date ranges say "11-06" to "28-06" ( 11th June to 28th June) for example so that if I enter say "20-06-21" (20th June 2021) into my textbox, it should display matched on my MsgBox alert.
I will be using multiple date ranges (maybe 5 or more) and I want to check all those ranges for the match.
If it matches in the first range, display "match 1"
In the second, "match 2" and so on.
I don't know how to do it. I will be glad if someone can pull it up for me.
Thanks in advance.
Kelly