Require vba code for user form

Hi Forum,

I am downloading the data from our company's web. And I have to check the THC details (Truck Hire Chalan ) Truck Hire, Advance and Balance with the hard copy. I have created userform where if I enter THC No. vba code have to seach this in the downloaded data in data sheet and should display Truck Hire, Adcance and Balance . (pls find attached file.)

eg. If I enter 1620120 it should search in "B" coloumn it is in cell b2 in Data sheet, and display

Truck Hire = M2,
Advance = p2,
Balance = q2

Below is the code I have recorded

Please Login or Register  to view this content.

Regards,
Nandkumar S.

Hi Nandkumar,

that THC nbr will be always unique nbr or any duplicate nbrs will come

Thanks for replying Naveed Raza and cfinch100,

I have made user form to check the THC details only. I don't want any input.

Naveed Raza, that THC nbr will be always unique nbr

Regards,
Nandkumar S.

glad here this , self practice is best practice good.

hi
the vlookup only looks at sheet, does not allow editing ,you could lock textbox properties if you wish,just use combobox to enter thc number
colin

thanks HaHoBe,

It is working very perfectly.

Regards,
Nandkumar S.

sir,

We do not want to change anything in the data except that once the THC is found while checking we need to mark (system date can be inserted against the checked THC no. in column "R") that THC number, so that the same can be deleted from the sheet.

Regards,
Nandkumar S.

Sir,

It works perfect after merged with code in post #5.

very thanks for your guidance,

Regards,
Nandkumar S.