RawlinsCross
Active Member
- Joined
- Sep 9, 2016
- Messages
- 437
Good day,
I've been running a spreadsheet macro that involves DTPicker. I initialize the DTPicker objects as follows. The problem is that each month's spreadsheet has to be updated with the new max and min dates for the new month. How do I improve this code so that the MinDate is always the 1st of the current month and the MaxDate is always the 1st of the next month? Does DTPicker need to be fed "mm/dd/yyyy" formatting?
I've been running a spreadsheet macro that involves DTPicker. I initialize the DTPicker objects as follows. The problem is that each month's spreadsheet has to be updated with the new max and min dates for the new month. How do I improve this code so that the MinDate is always the 1st of the current month and the MaxDate is always the 1st of the next month? Does DTPicker need to be fed "mm/dd/yyyy" formatting?
Code:
UserForm1.DTPicker1.MinDate = "9/1/2017"
UserForm1.DTPicker2.MinDate = "9/1/2017"
UserForm1.DTPicker3.MinDate = "9/1/2017"
UserForm1.DTPicker4.MinDate = "9/1/2017"
UserForm1.DTPicker5.MinDate = "9/1/2017"
UserForm1.DTPicker6.MinDate = "9/1/2017"
UserForm1.DTPicker7.MinDate = "9/1/2017"
UserForm1.DTPicker8.MinDate = "9/1/2017"
UserForm1.DTPicker1.MaxDate = "10/1/2017"
UserForm1.DTPicker2.MaxDate = "10/1/2017"
UserForm1.DTPicker3.MaxDate = "10/1/2017"
UserForm1.DTPicker4.MaxDate = "10/1/2017"
UserForm1.DTPicker5.MaxDate = "10/1/2017"
UserForm1.DTPicker6.MaxDate = "10/1/2017"
UserForm1.DTPicker7.MaxDate = "10/1/2017"
UserForm1.DTPicker8.MaxDate = "10/1/2017"
