Populating a Multi column Combobox in a userform

**anandvh** · 12-14-2012, 12:32 PM

Hi,

I am working on a project relating to employee management. I have created a UserForm which enables the user to select the employee for modification, reports, etc.

This userform has a combobox which I want to populate with an two dimensional array that has 4 columns and as many rows as there are employees. The employee data is stored in a worksheet called "PERS". I want the combobox to display the 4 columns as Employee ID (Column C), Surname (Column F), First name (Column G) and Middle Name (Column H). The data starts in row 3. Headers occupy rows 1 and 2.

I am having a problem with loading the combobox with the data. The code that I have currently is given below

Please Login or Register  to view this content.

I keep getting error "Subscript out of range" on the line

Please Login or Register  to view this content.

Can some one help point out where I have gone wrong and give the solution to populate the combobox. I have been searching the web for likely solutions but none have worked so far.

Please excuse if there is an elementary error - I am still low on the learning curve

Thanks in advance for your patience

Anand

**Norie** · 12-14-2012, 12:53 PM

Both of the dimensions of MyArray begin at 1 not 0.

**anandvh** · 12-14-2012, 01:01 PM

@Norie - I substituted iCol and iRow in my code above with 1. Now i get Run Time Error 1004 : Method 'Range of Objects'_Global' failed

Regards, Anand

**Norie** · 12-14-2012, 01:02 PM

Which line of code do you get the new error on?

**anandvh** · 12-14-2012, 01:07 PM

The error comes on the line

Please Login or Register  to view this content.

**Norie** · 12-14-2012, 01:10 PM

What's the value of iSou when you get the error?

Also, where do you give a value to iLst?

**anandvh** · 12-14-2012, 02:40 PM

The value of iSou = 3, the first row of data, which is correct.

iLst is not used anywhere and should have been deleted. iLst was declared to store the last populated row in the worksheet. Since tRow variable already stores this value, iLst is not used.

To give you a better idea of what I am trying to do, I have attached a sample workbook. Hope this will be of help

Regards,

Anand

**Norie** · 12-14-2012, 03:22 PM

Range should be Cells.

Actually that's not right.

What are you trying to refer to here?

Please Login or Register  to view this content.

Anyway, try this.

Please Login or Register  to view this content.

**anandvh** · 12-14-2012, 04:11 PM

Your codes works like a dream. I was able to get the mistakes I was making. This is the first time I am attempting to use a two dimensional array. My learning curve just went up a couple of notches.

Thanks Norie for your interest and assistance.

Regards,

Anand