Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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