Prev: conditional formatting
Next: Excel not opening properly when exported from Sharepoint
From: LuisE on 3 Mar 2010 22:17
I need to use comboboxes to update several pivot tables. What event should i
use to loop thru the changes to the comboboex and update the respective
fields of the different pivot tables?

I'm trying Worksheet calculate but it will keep going even though if i turn
the diableevents to false

Thanks in advance
From: Stefi on 4 Mar 2010 03:58
Isn't diableevents a typo? Maybe you meant Application.EnableEvents

--
Regards!
Stefi



„LuisE” ezt írta:

> I need to use comboboxes to update several pivot tables. What event should i
> use to loop thru the changes to the comboboex and update the respective
> fields of the different pivot tables?
>
> I'm trying Worksheet calculate but it will keep going even though if i turn
> the diableevents to false
>
> Thanks in advance
From: LuisE on 4 Mar 2010 10:14
yes that's what i meant

"Stefi" wrote:

> Isn't diableevents a typo? Maybe you meant Application.EnableEvents
>
> --
> Regards!
> Stefi
>
>
>
> „LuisE” ezt írta:
>
> > I need to use comboboxes to update several pivot tables. What event should i
> > use to loop thru the changes to the comboboex and update the respective
> > fields of the different pivot tables?
> >
> > I'm trying Worksheet calculate but it will keep going even though if i turn
> > the diableevents to false
> >
> > Thanks in advance
From: Stefi on 5 Mar 2010 06:13
Maybe

Private Sub ComboBox1_Change()

is the event you are looking for, but why do you want to set
Application.EnableEvents to False? That stops triggering all event subs.

--
Regards!
Stefi



„LuisE” ezt írta:

> yes that's what i meant
>
> "Stefi" wrote:
>
> > Isn't diableevents a typo? Maybe you meant Application.EnableEvents
> >
> > --
> > Regards!
> > Stefi
> >
> >
> >
> > „LuisE” ezt írta:
> >
> > > I need to use comboboxes to update several pivot tables. What event should i
> > > use to loop thru the changes to the comboboex and update the respective
> > > fields of the different pivot tables?
> > >
> > > I'm trying Worksheet calculate but it will keep going even though if i turn
> > > the diableevents to false
> > >
> > > Thanks in advance
 | 
Pages: 1
Prev: conditional formatting
Next: Excel not opening properly when exported from Sharepoint