Results 1 to 2 of 2

Thread: Case problem

  1. May 19th, 2006, 05:59 PM #1
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Case problem

    While running a Case, why can't I use the following instruction:
    VB Code:
    1. ActiveSheet.PivotTables("PivotTable3").PivotFields("Territory").CurrentPage = cbo1Selection
    Last edited by Fonty; May 23rd, 2006 at 12:42 PM.
    Reply With Quote Reply With Quote
  2. May 20th, 2006, 03:38 AM #2
    New2vba
    New2vba is offline
    Lively Member New2vba's Avatar
    Join Date
    Sep 2005
    Location
    UK
    Posts
    95

    Re: Case problem

    I assume this is a continuation of your previous post?

    I don't have any experience with pivot tables, but maybe your problem is due to the use of cbo1Selection, which is defined within a change event procedure for your combobox and you are trying to call it from another procedure.

    If the above is correct you will be getting a "variable not defined" error.
    Last edited by New2vba; May 20th, 2006 at 04:13 AM.
    "Those things we must learn to do, we must learn by doing" (or hope somebody else will take pity and help out )
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width