How to move inventory location using userforms

[edgardo5413]

I have a list of inventory by ID codes in column A and it's location in column B. I want to change the location (Column B) using a userform. In the userform I had a textbox to enter the ID code of the inventory that I want to move, and a comboBox of the locations (Departments) that I can choose. I want that when I press the Command Button, the useform look for the code I enter in the textbox and the codes in the Column A to change the location of the Inventory (Column B). (Like a query in access).

 

[bensonsearch]

Hi,

have you tried using the excel find and replace? or similar in VBA?

 

[edgardo5413]

ummmm, well i really need it in a formula...