Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a List Box with Macro

Hi,

I want to create a ListBox using macro and assign a column to spread values in listbox.

Thanks,

Chris

1 Reply
giakoum
Partner - Master II
Partner - Master II

sub CreateListBox

set vListBox = ActiveDocument.Sheets("Main").CreateListBox

set vProperties = vListBox.GetProperties

vProperties.Def.Name = "F2"

vListBox.SetProperties vProperties

set vProperties = nothing

set vListBox = nothing

end sub