topic Select in ListBox via VB Code in QlikView

Select in ListBox via VB Code

jduenyas — Tue, 06 Sep 2011 23:23:57 GMT

Hi all

can a selection of 2 or more items in a listbox be done via code in VB?

ActiveDocument.Fields("SalesRep").Select "ABC" works fine but how can I select more than just one, say "ABC" and "BCD" and "CDE"

Thanks

Josh

Select in ListBox via VB Code

kaushiknsolanki — Wed, 07 Sep 2011 04:44:42 GMT

Hi,

sub Select_Value
rem ** cancel selection of first selected value **
set f = ActiveDocument.Fields("SalesRep")
set fv = f.GetSelectedValues
fv.RemoveAt 0
f.SelectValues fv

rem ** select two non-consecutive field values in field **
set f = ActiveDocument.Fields("SalesRep")
set fv = f.GetNoValues 'empty array
fv.Add
fv.Add
fv(0).Text = "ABC"
fv(0).IsNumeric = false
fv(1).Text = "BCD"
fv(1).IsNumeric = false
f.SelectValues fv

end sub

Regards,

Kaushik Solanki

Select in ListBox via VB Code

jduenyas — Wed, 07 Sep 2011 15:17:35 GMT

Thank you!

Every such little hint helps build up the knowledge.

Much appreciated.

Josh