Results 1 to 3 of 3

Thread: Display pivot table data in userform

  1. #1
    Seeker thousand's Avatar
    Join Date
    Apr 2017
    Posts
    17
    Articles
    0
    Excel Version
    2010

    Red face Display pivot table data in userform



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I currently have this vba which works perfectly displaying data from pivot table. However, this only works when there are less than 32 columns.
    Is there a way to display pivot table data but only for specific columns.

    Thanks in advance
    Private Sub Workbook_NewSheet(ByVal Sh As Object)
    If ActiveSheet.Name <> "worksheetname" Then
    ActiveSheet.ShowDataForm
    End If
    End Sub

  2. #2
    Seeker thousand's Avatar
    Join Date
    Apr 2017
    Posts
    17
    Articles
    0
    Excel Version
    2010
    Solved

  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,395
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Care to share your solution with the board?
    Thank you Ken for this secure forum.

Tags for this Thread

Posting Permissions

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