Compile Error: VBA choosing multiple selections from PivotTable.

[saudi_red_neck]

Hello friends, Hope all is well!

Trying to choose multi choices from Pivot table with VBA, but I keep getting the following error.

Please help, and thank you very much in Advance!

Compile Error: Variable Required - Can't assign to the is expression.

Please Login or Register  to view this content.

[TMS]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[GC Excel]

Hi,

Try this :

Please Login or Register  to view this content.

[saudi_red_neck]

Hello again!
the code is not having any effect on the pivottable, i.e. not filtering. So, I put a single quotation mark on: ' On Error Resume Next '(Can't hide all fields)

and when I ran the code I got the following error: Run time Error 1004:
Application Defined or object-defined error.

Please help

[GC Excel]

What's the name of your pivot table ?
I put "Pivot Table1" in the code but it was not clear in the code you provided.

[saudi_red_neck]

pivot table name is: PivotTable1. btw the field is placed in in the row section. and it is a powerpivot. does that matter?

[rorya]

and it is a powerpivot. does that matter?

Yes. I'd pretty much guarantee none of the items have the names in your lists for an OLAP pivot table.

[saudi_red_neck]

Hello again, sorry stuck again. the code works smoothly with PivotTables.
But, can you please help me with having the code of case (Case "05100045", "03036001", "03036002", ...etc),
read from whatever values listed is in the range A1:A100 of sheet "ABCDB".

that would be better than placing the cases manually in the code itself.

Your kind help will make the code far better. Thank you very much in advance!

Please Login or Register  to view this content.

[GC Excel]

Hello,

Here's a suggestion. You'll have to change the sheet name.
The idea is to store the values in a dictionary and compare after.
(assuming the values in A1:A100 are in string format "05100045", not number format like "5100045".

Please Login or Register  to view this content.

[saudi_red_neck]

Thank you GC, for some reason no change. I placed the attachment for testing purposes if you don't mind.

formatting seems fine.

Truly grateful; many thanks!

[GC Excel]

Hi,

A small modification required to the code according the to sample sheet you provided:

Please Login or Register  to view this content.