How to create a List Box with Macro

Sat, 12 Oct 2013 20:10:45 GMT

Hi,

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

Thanks,

Chris

Re: How to create a List Box with Macro

giakoum — Sat, 12 Oct 2013 21:15:16 GMT

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