98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
Excel VBA
Resolved · High Priority · Version 2003
Fri 5 Aug 2011, 10:24Delegate Tony said...
Tony has attended:
Excel VBA Advanced course
Excel VBA
What is the code to activate a drop down in the 'page' section of a pivot table, then choose an item from the list?
Thu 11 Aug 2011, 15:07Trainer Anthony said...
RE: Excel VBA
Hi Tony, thanks for your query and apologies for the delay. If you had a "Model" field in the page section, you'd manipulate it and choose the "Corvette" option like so:
ActiveSheet.PivotTables("PivotTable1").PivotFields("Model").CurrentPage = "Corvette"
Hope this helps,
Anthony
Thu 18 Aug 2011: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
