VBA code to fill a cell in a column based on another column

What is the VBA code to use, if i want to input some cylinder numbers from the "masterlist" sheet (column no.cyl) to the textbox cylinder 1 to 10 on the user form (sheet JCO, click on home button, choose JCO), then at the column "status" will be shown "Ready" at the same row with the no.cyl we've inputed.

Really need help... thanks a lot

Please change your thread title as per forum rules and add a sample sheet instead of a picture - Thx

Just to make sure I understand, you want to put a cylinder number in some of the 10 textboxes on your JCO userform and then click the "ok" command button. Once the command button is clicked you want to find those cylinder numbers on the Masterlist sheet and have column F (status column) read "Ready". Is this correct?

If you place this in a standard module then you could call it from your OK button code.

Please Login or Register  to view this content.