Consulting

Results 1 to 8 of 8

Thread: how to use userform to operate pivot table

  1. #1
    VBAX Regular
    Joined
    Aug 2019
    Posts
    14
    Location

    how to use userform to operate pivot table

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

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,638
    Use slicers.

  3. #3
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,872
    Quote Originally Posted by snb View Post
    Use slicers.
    viz.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  4. #4
    VBAX Regular
    Joined
    Aug 2019
    Posts
    14
    Location
    Actually i need this, could u help me plz

  5. #5
    VBAX Regular
    Joined
    Aug 2019
    Posts
    14
    Location
    tnx p45cal , i know this but i need combobox of userform very badly, plz help

  6. #6
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Cross-posted at Excel Forum
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  7. #7
    VBAX Regular
    Joined
    Aug 2019
    Posts
    14
    Location
    plz help me, plz.........plz

  8. #8
    VBAX Regular
    Joined
    Aug 2019
    Location
    Kuwait
    Posts
    9
    Location
    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •