I have copied a Word table into an Excel spreadsheet and created a defined name to refer to it. There are 6 columns and 50 rows in the defined name called ScheduleList. I want to use each row in ScheduleList to populate a combobox in the same sheet. I am thinking of doing something like:
What is the best way to accomplish this?
Code:
For each row in ScheduleList
schedCombo.ControlFormat.AddItem ScheduleLIst(row, 1) + ScheduleList(row,2)
next row
What is the best way to accomplish this?