How to make autofill textbox based on value in textbox1?

[meloception]

Hi. i'm new to Excel programming. i need help.

i have a sheet called "List" which contain
column A = ID (No.Maktab)
column B = Name
column C = grades
column D = classes

i created a userform where i want textbox 2-4 autofill/populate based on sheet "List" when i enter a value in textbox1 (ID/No.maktab). how do i do that?
thank you.

[Takae]

Please try this code.

Please Login or Register  to view this content.