Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msg Box to appear when page selection changes in a Pivot Table
Use the WorksheetSelction Change event and check the target range....
Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub If this post helps click Yes --------------- Jacob Skaria "Mustang" wrote: Does anyone know how I can create a macro that will run each time the Page selection changes in my Pivot Table to display a message box? I basically want to remind them to copy a total amount to another sheet. Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msg Box to appear when page selection changes in a Pivot Table
Hi thanks for your speedy reply.
My knowledge of VB is minimal. Can you give me a bit more guidance as to what to put in the code please. I am a bit lost here sorry. "Jacob Skaria" wrote: Use the WorksheetSelction Change event and check the target range.... Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub If this post helps click Yes --------------- Jacob Skaria "Mustang" wrote: Does anyone know how I can create a macro that will run each time the Page selection changes in my Pivot Table to display a message box? I basically want to remind them to copy a total amount to another sheet. Many thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msg Box to appear when page selection changes in a Pivot Table
Assuming my Range as A1:C3 of Sheet1; copy the below code to the Selection
Change event. Launch VBE using Alt+F11 from workbook. From the left treeview double click Sheet1(Sheet1) Drop down to get the 'Worksheet' 'Selection Change' event paste the code...so as to look like. Select any cell from A1:C3 in Sheet1... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Application.Intersect(Target, Range("$A$1:C$3")) Is Nothing Then MsgBox "OK" End If End Sub If this post helps click Yes --------------- Jacob Skaria "Mustang" wrote: Hi thanks for your speedy reply. My knowledge of VB is minimal. Can you give me a bit more guidance as to what to put in the code please. I am a bit lost here sorry. "Jacob Skaria" wrote: Use the WorksheetSelction Change event and check the target range.... Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub If this post helps click Yes --------------- Jacob Skaria "Mustang" wrote: Does anyone know how I can create a macro that will run each time the Page selection changes in my Pivot Table to display a message box? I basically want to remind them to copy a total amount to another sheet. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Synchronize the Pivot table page field selection in 2 tables? | Excel Worksheet Functions | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) | |||
VBA Code for a pivot table to open database and to reference table current page | Excel Programming | |||
Pivot Table - Multiple Pivot Field Selection | Excel Programming |