Select multiple values in pivot table using userform text boxes

Hello,
I have created a userform that allows a person to type in up to 10 branch IDs (i.e. 1000, 1001, 2003, 3005, etc.) in text boxes. I am trying to make it so that when they enter multiple branches they will be selected in the pivot table. Here is the code I am using, where txtBMBranch# is the name of the individual text boxes.

Any help would be greatly appreciated. Thank you in advance.

Please Login or Register  to view this content.

Right now the code unchecks "Select Multiple Items" and doesn't choose any branch ID entered.

"Branch ID" is in the Report Filter section of the pivot table.

bump bump bump