Auto populate Textboxes fro Combobox selection

Hi,

I've just read a few similar threads but cant seem to work out my problem

I am using the following code to show only the unique:

Please Login or Register  to view this content.

Following the 'NJReportedCB' there are 2 Textboxes: 'NJTelephoneTB' & 'NJEmailB'.

How can I get the 2 Textboxes to auto fill with the corresponding data from the ComboBox selection's row.

I thought this was really simple but i'm struggling and getting stressed

Any help greatly appreciated.

Thanks,

Cuba

The reported always has the same telephone and email, there is many rows that show Reception, 020 7123 4567 and [email protected] in columns E, F & G.

I am trying to avoid making another table for contact details and typing them out every time is defeating the goal of the userform.

I can't get it to work!

Should I be placing it under UserForm_Initialize() or somewhere else?

I don't understande why you need a textbox for tel# that is in Combobox...

Please Login or Register  to view this content.

OK, Sorry, don't think I'm getting it, probably my rubbish description.

Here's an example.

Example3.xlsm

When a selection is made from the 'Reported By' ComboBox1 I would like it to automatically fill the following Textboxes from the entries already in the table.

Thanks again and Happy New Year

But it has all the code... Please Help

If this is not what you wanted, just ignore it.

This works great in the example but when I copy the code in to my app it throws up a compile error when I make a selection from the combobox!

Sub or Function not defined

Would it be possible for comments to be put in the code so I understand what's happening?

The Debuging highlights the Combobox and the line: .NJTelephoneTB = Dic(.NJReportedCB.Value)(0) The Dic is highlighted!