Reference ListBox Show.Always/Show.Condition property in VB Macro.

[#1]

Hello,

I am using a macro, I want to be able to make a listbox visible and invisible:

How do I reference(and set)

Show.Always
Show.Condition

for a Listbox ?

Thank in Advance !

Tim

[deepakk]

check out this forum...

http://community.qlik.com/forums/t/36579.aspx

[#3 · Accepted solution]

That worked for me, thanks Deepak!

(I would still like to know how to reference those properties directly though)

[gandalfgray]

You can do it like this:

sub setlb01
set LB = ActiveDocument.GetSheetObject("LB01")
set boxprop=LB.GetProperties
boxprop.Layout.Frame.Show.Always = false
boxprop.Layout.Frame.Show.Expression.v = "sum(Sales)>4000"
LB.SetProperties boxprop
end sub

[#5]

Thank You

[#6]

That worked for me too! A great way to control the show condition via macro.