excel - Iterate over slicer via VBA and select a single item each time -

-

i have several slicers within spreadhseet. i'd able loop on 1 of these via vba, , select every option 1 one. macro below seems fine tired eyes, doesn't work when run it. when add breakpoint @ 'breakpoint tag here below, first item gets selected, macro goes second 1 while keeping first 1 selected , end items selected...

    sub slicers(slname string)     dim slitem sliceritem, sldummy sliceritem     dim slbox slicercache     set slbox = activeworkbook.slicercaches(slname)     each slitem in slbox .sliceritems       each sldummy in slbox .sliceritems           sldummy.selected = (sldummy.name = slitem.name)       next sldummy     next slitem 'breakpoint     end sub      sub test()     call slicers("a_slicer_name")     end sub

thanks help

edit:
pointed out scott holtzman, turns out need clear filter (slbox.clearmanualfilter) upon selecting new item.

why necessary whereas boolean test works when debug.print it?

the code below works fine:

    sub slicers(slname string)     dim slitem sliceritem, sldummy sliceritem     dim slbox slicercache     set slbox = activeworkbook.slicercaches(slname)     each slitem in slbox .sliceritems       slbox.clearmanualfilter 'this line needed add       each sldummy in slbox .sliceritems           sldummy.selected = (sldummy.name = slitem.name)       next sldummy     next slitem     end sub      sub test()     call slicers("a_slicer_name")     end sub

since question linked in comment not have accepted answer (the user never choose answer or reply suggestion), provide solution problem here well.

sub slicers(slname string)      dim slitem sliceritem, sldummy sliceritem     dim slbox slicercache      set slbox = activeworkbook.slicercaches(slname)      'loop through each slicer item     each slitem in slbox.sliceritems          'show items start         slbox.showallitems 'or .clearmanualfilter          'test each item against         each sldummy in slbox.sliceritems              'if item equals item in first loop, select             'otherwise don't show (thus showing 1 @ time between nested loops)             if slitem.name = sldummy.name sldummy.selected = true else: sldummy.selected = false              'more code process data (i suspect)          next sldummy      next slitem  end sub

Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

android - Go back to previous fragment -

-
btw second fragment. appear once press button in first fragment. in fragment, if press button on phone, go previous fragment. need guys. in advance. public class listalldoctorfragment extends fragment { button close; @nullable @override public view oncreateview(layoutinflater inflater, viewgroup container, bundle savedinstancestate) { view view = inflater.inflate(r.layout.listalldoctor, container,false); close = (button) view.findviewbyid(r.id.button); close.setonclicklistener(new view.onclicklistener() { @override public void onclick(view view) { android.app.fragmentmanager fm = getfragmentmanager(); fragmenttransaction ft = fm.begintransaction(); shit f2 = new shit(); ft.add(r.id.content_frame, f2); ft.addtobackstack(null); ft.commit(); } }); return view; } } assuming want g...
Read more