I have created a form that pops up when I open a new template. In that form I have inserted a combo box that I want to be able to select data from a separate spreadsheet that is on our server. What code do I need to write to link this data to my combo box. Below is what I have written.
Private Sub UserForm_Initialize() 'Add list entries to combobox. The value of each 'entry matches the corresponding ListIndex value 'in the combo box. cbSiteAddress.AddItem ("P:\Accounts\Billing Schedule.xls'MASTER SCHEDULE'!A5:A103") 'Use drop-down list cbSiteAddress.Style = fmStyleDropDownList 'Combo box values are ListIndex values cbSiteAddress.BoundColumn = 0 'Set combo box to first entry cbSiteAddress.ListIndex = 0 End Sub
Can anyone help me?