(updating inventory using user form) : Assign macro to "Çheck Availibility" command button

Hi guys.

I need some help here. I want a macro that can update the inventory by using the user form. I need a macro to be assigned on "check availability" command button.

Every time the user insert the item code in textbox1, the macro will identify the value in textbox1 which match the code in database column C.Then, it will display the respective quantity in column I into textbox2 (user form).

However, if the textbox1 (user form) = "" or value in textbox1(userform) doesnt not exist in database, the macro need to display "Not available" message.


Here are the the code that i try to modify, but it doesnt fully work on certain condition

Please Login or Register  to view this content.

I hope you can help me on this. Thanks in advance. Really appreciate your help.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code (not [quote][/quote ] tags). Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hello pyol17,

You don't need the "Check" button. I have changed the form for you to check the availability without using the button. The updated workbook is attached.