[SOLVED:] how to use userform to operate pivot table [Archive]

View Full Version : [SOLVED:] how to use userform to operate pivot table

emmr

08-09-2019, 02:41 AM

is it possible to operate pivot table through userform of vba..
if yes, how i can do this..
attachment for your convenience
TIA

snb

08-09-2019, 03:29 AM

Use slicers.

p45cal

08-09-2019, 05:57 AM

Use slicers.

viz.

emmr

08-09-2019, 05:58 AM

Actually i need this, could u help me plz

emmr

08-09-2019, 07:23 AM

tnx p45cal (http://www.vbaexpress.com/forum/member.php?3494-p45cal) , i know this but i need combobox of userform very badly, plz help

Bob Phillips

08-09-2019, 08:32 AM

Cross-posted at Excel Forum (https://www.excelforum.com/excel-programming-vba-macros/1285918-how-to-use-userform-to-operate-pivot-table.html#post5173410)

emmr

08-10-2019, 12:46 PM

plz help me, plz.........plz:crying:

mse330

08-13-2019, 06:39 AM

I don't know what is your ultimate goal or what you are trying to acheive but I do agree with everyone that using the built-in slicers is much easier. Anyway, check the attached file for what you've asked for