Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Pivot Tables in VBA
Jim has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Hi
What is the code to exclude an item in a drop down box of a row in a Pivot Table in VBA
The options for countries are:
'show all',
'England',
'Wales', &
'Scotland'
I want to uncheck the 'Scotland' box so only England and Wales appear in my Pivot Table
Functions in Excel can be difficult to recall their format/syntax
For example, you want to use the =PMT function.
Enter =PMT, then select keystroke, CTRL+SHIFT+A.
This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
