Hi

I know i ask similer question before but this one bit more complex!

Ok let me make it as simple as i can, i have in sheet1 three column A,B,C,
in (column A) names, in (Column B) Fone No, and in ( column C) Email.

In sheet2 there is Combo box but this combo box is from CONTROL TOOL BOX NOT
FROM FORMS!! so let say i select name from thjat combo box then below it it
iwll show fone no and below that email of that person i selected.

Note: i know how to view fone No but i do not know how to view the email at
the same time.

Please help me guys and thank u very much and i will be looking forward to
hear from u soon