ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 6,002
- Office Version
- 2024
- Platform
- Windows
I’m a bit lost without the Datepicker option on my userform.
So as poor as it is I’m thinking of having some option buttons or checkboxes where they could be selected, let’s say 6 of them & each one in turn would show current day, next one todays date -1 date, next one would show todays date -2 days etc etc.
Currently my existing code would look for the value in Textbox12 which would be the current day then pass that date to my worksheet.
So advice is needed for the code to take onboard the above & apply the option or checkbox which relates to a date in question then pass to the worksheet.
Basically my goal is when date picker was in use I could select a date 3 or 4 days previous to the current date & it would be put on my worksheet
So I’m trying to have the same kind of previous date selection.
Any suggestions welcome.
So as poor as it is I’m thinking of having some option buttons or checkboxes where they could be selected, let’s say 6 of them & each one in turn would show current day, next one todays date -1 date, next one would show todays date -2 days etc etc.
Currently my existing code would look for the value in Textbox12 which would be the current day then pass that date to my worksheet.
So advice is needed for the code to take onboard the above & apply the option or checkbox which relates to a date in question then pass to the worksheet.
Basically my goal is when date picker was in use I could select a date 3 or 4 days previous to the current date & it would be put on my worksheet
So I’m trying to have the same kind of previous date selection.
Any suggestions welcome.