VB code: populate combobox from columns in Excel file

[billybeach]

Hi,

I am creating a custom form for the calendar in Outlook in wich I can add a number code in front of the subject. The code can be selected in a combobox. I managed to do this with predefined values. But I would like to populate the combobox values from two columns of an excel file which will change sometimes.

I really am new to VB script and tried searching for codes online but most of them I can't get to work...

Like this one:

http://www.vbforums.com/showthread.p...om-Excel-Range

It would be nice if someone could help me with this. Thanks!

[billybeach]

If it is easier to populate the combobox from a txt-file, this could work for me as well. Thanks!

[niton]

I have not tried it but you should be able to make this work in Outlook.

http://gregmaxey.com/word_tip_pages/..._combobox.html

http://www.vbaexpress.com/kb/getarticle.php?kb_id=179



*******************
Consider rating the thread by going to the "Rate Thread" dropdown.