Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture Filter 'AfterUpdate' event in Pivot Table
Hi,
1. I have a pivot table that shows price data vertically for 30 stock ticker symbols, by stock symbol and date.. There is a verying number of rows for each respepctive stock symbol. 2. A Filter dropdown box on the Stock Symbol column allows selection of all or some of the stock symbols. 3. At the bottom of the entire table, at row 1650 when Show All is chosen, is a TextBox with a 30-line disclaimer. 4. My goal is to have this disclaimer displayed immediately under the last data row of the stock ticker symbol(s) selected. This is a legal requirement. 5. PROBLEM: If I choose say only one stock and the last data row is 200, the Disclalimer textbox is still displayed at row 1650, with 1450 blank rows between the last data row and the disclaimer. . 6. Hence, I need a way to capture an 'AfterUpdate' event for the dropdown box and A. Get the last row number of the data displayed, based onn the stock symbol(s) chosen, and B. Move the Disclaimer textbox to that last row number + 2. It might be easier if I put the text in a named range of cells instead of a text box, but either way, I need to re-position the Disclaimer. Is there a way to do this each time a different selection is made from the filter dropdown?? Thanks for any help you can give. Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
afterupdate event in Excel | Excel Programming | |||
Pivot table filter - Selected Item Event | Excel Programming | |||
PivotField AfterUpdate event? | Excel Programming | |||
Capture Pivot table filter count | Excel Programming | |||
AfterUpdate Event not Running | Excel Programming |