Populate two form fields based on combo box selection

[rjrjenkins]

Hi,

First poster so please be kind. I will provide as much info as possible.

I have a User Form in Excel 2003. On the form is a combo box called "cbclient" which draws its values from Column A of a worksheet called "ClientList". When a selection is made from this combo box, I would like two other fields on the User Form, namely "tbaccmgr" and "tbsystem" to populate with the corresponding values from within the same table on the "ClientList" worksheet. This table has 3 columns: Column A = Client (which is the column which populates in the "cbclient" combo box.) Column B = Account Exec (this is the column from which I want the corresponding value to be put into "tbaccmgr") and Column C = System (from this column is the corresponding value I want to be put into "tbsystem".)

Any help would be hugely appreciated.

Thanks