User form for pivot

[Veeru106]

Hi,


I need a code for user form , where if we select something in userform it automatically select same thing in pivot.


Let’s say if I select ADM in Business Group, GSC in Customer, Site office mgmt. in Process, Adm (Site) and Site (BLR) in user form, it should select same thing in pivot.


I was wondering if we can link user form with the Sel tab,, then go the basis of Sel tab we can link it to pivot. Just a suggestion


Thanks in advance

 

[Veeru106]

what i mean is...userform can look like this ...Doc file attached