Search for date & city and chose checkbox

I have a userform that I am trying to setup. I want it to search column "B" for the date that was put in Textbox1 then search range (D8:M8) for the city name then if Checkbox1 ("AM") or Checkbox2 ("PM") in range (D7:M7) and at the intersection I want it to add a 1 to that cell. The numbers need to be a running number so if it do the procedure twice then it would equal 2, if I did the procedure 15 times, the number in that cell would be 15. I'm just starting with VBA again & the following code is what I have so far but no luck. I have attached my book for your assistance & I greatly applicate any help that I would be able to get with this!

Please Login or Register  to view this content.

It works like it supposed to but each box should start with zero. Meaning if cell F17 is zero then when I select "Chicago" "1/2/2019" & "AM" it would change to 1. If I select "Boston" "1/1/2019" & "PM" then cell E16 would change to 1. Each cell would count up from zero. I hope that makes sense.

Awesome - thank you so much that works perfectly!!! Is there away I can tie a calendar to this sheet so it corresponds with the values in the cell? Basically have a calendar with a drop down to select the City & it shows the month for that calendar and show large numbers of how many are in that cell?

What I am trying to do is create a master file for myself so I can blackout dates. I am the only one going to be using this workbook. I would like a book that shows a calendar for each location showing how many jobs are available for that location. Is that possible? I have attached a calendar book that I was working on which I have attached but, any help or ideas would be greatly appreciated!

Thank you so much for your help. However I need a little more assistance! When I click on a block where the AM/PM is located I would like userform 4 to popup which I have done but I would like for the label at the top to populate with the location <br> then the date that was selected. I have uploaded what I have so far! Any assistance would be greatly appreciated. I also have a "database for our customer's info. When I click on the cell I would like for it to show who currently is scheduled for that day weather it be am or pm & have the ability to remove or add the info from userform 4. I have attached my workbook so you can see what I am trying to do.