Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Pivot Tables in VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Pivot Tables in VBA

Resolved · Low Priority · Version 2003

Reply Fri 13 May 2011, 11:51Delegate Jim said...

Jim has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Pivot Tables in VBA

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

For upcoming training course dates see: Pricing & availability

Reply Fri 13 May 2011, 12:05Delegate Jim said...

RE: Pivot Tables in VBA

Don't worry, I have resolved it now.

Excel articles

· Finding Your Way Around Excel 2007
· How To Use The Cell Styles Functionality In Excel 2010
· Let Excel look after the pennies, and the pounds will take care of themselves
· Customize Your Gridlines And Borders In Excel 2007
· Do You Really Need Excel VBA Training?

Please browse our web site to find out more about
microsoft+excel+training+course and other Microsoft training courses.

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips