userform textbox that searches column b

I have spent hours scrolling up and down this sheet looking for part numbers, so I created a userform with 2 textboxes. I want to enter a part number in the first textbox, and have the macro select the cell in column B that contains that part#. Then I will tab to the second textbox and enter a quantity. When I tab back to the first textbox, the quantity should paste into the next empty cell in the same row of the part# from textbox 1.

Please Login or Register  to view this content.

On first tab, cell B7 would be selected, on second tab, 500 would be placed in cell D7.

I tried converting code from a similar post, but I ended up with extra code that crashes excel every time I try to save the file.

Any help is appreciated,

Thank you


(I already know how to create a userform and set up tab orders)

Hi,

Try something like..

Please Login or Register  to view this content.

HTH

Originally Posted by Cheeky Charlie

Fixing this might be quicker than starting from scratch - perhaps you could post it (don't forget code tags).

HTH

Ok, actually the first textbox is actually a combobox (sometimes I dont have to type the whole part# because of the rowsource) "cbo1"

The original code would search a column on multiple sheets. I want it to stay on the same sheet (Adjust1!).

Please Login or Register  to view this content.

Originally Posted by Cheeky Charlie

That's not very nice - try this:


Although I'm not sure what was causing a crash - this might be something to do with other coding elsewhere(?)

CC

That very well could be. Its a complex (for me anyway) multiple file inventory tracking spreadsheet.

A couple people didnt show up for work today, so I probably wont have time to test this today. Im sure it will work fine, I will let you know when I can get to it.

Thank you,