Combo List box

[Gibbie]

I have created a combo list box and need to import a list of schools from
excel. How to I enter the array so I can import this list instead of typing
in as shown???
Private Sub UserForm_Initialize()

ComboBox1.ColumnCount = 1

'Load data into ComboBox

ComboBox1.List() = Array("Ascension of Our Lord", "Bishop Carroll",
"Bishop Grandin", "Bishop Kidd", "Bishop McNally", "Bishop O 'Byrne",
"Blessed Brother Andre Centre", "Blessed Damien",

 

[Doug Robbins]

See the article "Load a ListBox from a Named Range in Excel using DAO" at:

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP