<div>
Beautiful, would I be able to easily cross reference other pertinant information easily. ie if I loaded this list to a combo box and someone selected company 'ABC' could I autopopulate other fields such as the contact name email etc.<br />
<br />
Keep in mind I'm looking for an easy solution for instance, If there is an index number you are keeping track of in your code so I don't have to write a complicated routine for cross referencing. Otherwise no need to answer as I will go about it the long way.
</div>


Beautiful, would I be able to easily cross reference other pertinant information easily. ie if I loaded this list to a combo box and someone selected company 'ABC' could I autopopulate other fields such as the contact name email etc.

Keep in mind I'm looking for an easy solution for instance, If there is an index number you are keeping track of in your code so I don't have to write a complicated routine for cross referencing. Otherwise no need to answer as I will go about it the long way.

<div>
No Comments were added to the code
</div>


<div>
You could expand the array to store as many fields as you wish, and then they would be available for selection in the combo box.
</div>


You could expand the array to store as many fields as you wish, and then they would be available for selection in the combo box.

<div>
If you wish, you could post another question, mentioning which fields you want to store, and I could do some modified code.
</div>


If you wish, you could post another question, mentioning which fields you want to store, and I could do some modified code.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I'd like to import all of our contacts (company name) to a combo box via VBA code in Excel.
</div>
</div>


Hello Experts,

I'd like to import all of our contacts (company name) to a combo box via VBA code in Excel.

Import Company Name from Outlook to a combo box in Excel using VBA

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.