This is a bit complicated and I am trying my best to explain it.

I am trying to find a VBA code which triggers input box when specific criteria is found in data.

The data has a transaction codes and when criteria from columns A,B,C match it means it is 1 delivery.
Criteria for a delivery is (Part 1,Identify, PERM-CRE-LOC).


ColumnA ColumnB ColumnC
Part number Activity code Operation code
Part1 Piece-pick PERM-CRE-LOC
Part1 Identify PERM-CRE-LOC
Part1 General-movement PERM-ADJ-LOC
Part1 Identify PERM-CRE-LOC




By using this formula it returns a value of 2: COUNTIFS($A:$A,""Part 1"",$B:$B,""Identify"",$C:$C,""PERM-CRE-LOC"") . Which means I had two deliveries.
Is there a way a VBA can do this search and when it finds the matched criteria(delivery) then it triggers the input box?

I would like input box to give two options:
1st type in the quantity and 2nd to type in the quantity. Then the typed quantity placed in a different worksheet in specific range? i.e "Worksheet1" range A2 for 1st input and range B2 for 2nd input.
Can input box also display the number of total found criterias (Deliveries)?. Please help.

Many thanks