I am creating a userform that will allow the user to select a specific date range, and then when the command button is selected, it will sort data on the worksheet that falls between the 2 dates.
I need help with the code that will be executed once the command button "cmdGetReport" is selected.
The start date and end date are captured into textboxes. "txtDateBox2" is for the start (the 'from' date) date, and "txtDateBox3" is the end (the 'to' date)
The worksheet where the data resides is named "Seatex Incident Log"
The date column where the dates are stored is in column B. The data starts on row 18 and goes down to the last row present on the worksheet (currently that is row 518.) and also goes over to the last column (which is "AG" (column 33) )
Also... I am using a datepicker for choosing the start(from) date and the end (to) that way only the same method of entering a date is used as well as ensuring that each of the dates that are chosen are placed into txtDateBox2 and txtDateBox3 in the same format and date style
Here is the (simple) form that I have so far... later I am going to be adding checkboxes that will be used for selecting specific criteria within the data that is found within the date range: (pic also shows the worksheet where the data is including column B that contains the date)
Thanks in advance for any help!!
I need help with the code that will be executed once the command button "cmdGetReport" is selected.
The start date and end date are captured into textboxes. "txtDateBox2" is for the start (the 'from' date) date, and "txtDateBox3" is the end (the 'to' date)
The worksheet where the data resides is named "Seatex Incident Log"
The date column where the dates are stored is in column B. The data starts on row 18 and goes down to the last row present on the worksheet (currently that is row 518.) and also goes over to the last column (which is "AG" (column 33) )
Also... I am using a datepicker for choosing the start(from) date and the end (to) that way only the same method of entering a date is used as well as ensuring that each of the dates that are chosen are placed into txtDateBox2 and txtDateBox3 in the same format and date style
Here is the (simple) form that I have so far... later I am going to be adding checkboxes that will be used for selecting specific criteria within the data that is found within the date range: (pic also shows the worksheet where the data is including column B that contains the date)
Thanks in advance for any help!!