Hi Garry,

Agreed. I really appreciate you taking a look and trying. In the
meantime today, I had a thought for a sort of work around. It's not
perfect, but it's close. I'm still using the double-click event on
the Output sheet, which is putting the selected catalog number into a
variable, switching to the slicer sheet, putting that variable into a
specified cell, and the copying that cell to the clipboard. Then the
user doesn't have to remember or fatfinger in the number, but rather
just select the pivot table drop down and paste into the search field.
It works.

Again, THANK YOU for all your time and attention to my issue!

Frank

Interestingly, I was looking at a Contextures solution that does something
similar via a userform. You might want to persist checking that site out...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion