M
mugitty
I have a workbook that is used for scheduling deliveries.
Sheet 1 is a "Control Panel" which among other things will pop up an
entry form for "New Deliveries".
Sheet 2 is set up as a list which receives the data from the userform.
This all works as desired presently, but I want to write the data from
the userform to a separate sheet by month based on the delivery date
entered on the form.
The form has a permanently visible calendar which when clicked writes
the selected date to a text box right below the calendar (as
mm/dd/yy).
How can I pull the month only from the text box and use it to determine
which of the monthly sheets will be activated for writing the data from
the form?
Sheet 1 is a "Control Panel" which among other things will pop up an
entry form for "New Deliveries".
Sheet 2 is set up as a list which receives the data from the userform.
This all works as desired presently, but I want to write the data from
the userform to a separate sheet by month based on the delivery date
entered on the form.
The form has a permanently visible calendar which when clicked writes
the selected date to a text box right below the calendar (as
mm/dd/yy).
How can I pull the month only from the text box and use it to determine
which of the monthly sheets will be activated for writing the data from
the form?