+ Reply to Thread
Results 1 to 1 of 1

Windows text box from pivot table

  1. #1
    Registered User
    Join Date
    07-12-2013
    Location
    Jersey
    MS-Off Ver
    Excel 2010
    Posts
    59

    Windows text box from pivot table

    click on cell.xlsx

    Dear Excel Forum

    I have a 2 way table and when I click on a cell I can write the vb code to display "Hello World", but instead I am trying to display the raw data in a list in a message box.

    In the attached workbook I have the raw data, 2 way table(pivot table) and the desired outcome.

    Hope you can help.

    Kevin
    Last edited by kevincoxshall; 09-07-2014 at 08:31 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Windows text box from pivot table

    Standard code module
    Please Login or Register  to view this content.
    worksheet code. right click sheet tab of sheet with pivot table on and View Code.
    Please Login or Register  to view this content.

    Message bozes have a limit on the amount of text shown so you may need to use a userform if your real data set is large.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. pivot table with text
    By sinisaj in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-14-2013, 01:22 AM
  2. Text in Pivot Table
    By rhostetler in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-01-2013, 04:13 PM
  3. [SOLVED] Match row that contains text text string; list associated values from pivot table
    By ACurtis802 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2009, 07:50 PM
  4. Replies: 1
    Last Post: 04-15-2008, 01:59 AM
  5. Pivot Table Text
    By kkondrat1 in forum Excel General
    Replies: 0
    Last Post: 01-26-2005, 05:14 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1