Userform and for Inventory

I have searched around, but am unable to find anything specific to what I am wanting to do. Basically, I am creating an inventory worksheet, and wanting a userform to come up when data is entered into a cell. For example, when a UPC is entered into a cell, a userform comes up asking for a quantity to be entered. The user is presented with an OK or Cancel button. I have found examples to have the userform come up on a change event, and entering a quantity and hitting OK enters that value into a desired cell. However, what I am wanting for the cancel button is to not just close the userform, but also clear the contents of the "Target" cell that triggered the userform.

Hope that makes sense and someone can help with my VBA!

Hi and welcome

What range of cells will trigger the userform and where should the number entered be output to?

BSB

Forum rules dictate that I cannot help further until you add code tags to your last post. Edit the post, highlight the code then click on the # icon in the buttons above the text window then save the changes.
It may be worth also adding a sample workbook as it will be easier to help with that.

BSB

Try this in your worksheet module:

Please Login or Register  to view this content.

This in your userform module:

Please Login or Register  to view this content.

Add this to the standard module:

Please Login or Register  to view this content.

See attached. Does that do what you need?

BSB

That works exactly as I wanted, thank you! Is it easy enough to add additional fields to this without to much hassle - like, if I wanted to add a Name or Location field?

Glad I could help

Add additional fields in what way? So the form has more than just quantity on it?

BSB

Meant like adding additional fields besides just quantity, and have those entered fields be entered into other cells on the worksheet. After some fiddling, I figured it out. Thanks again for your help!

One I submitted a few weeks back to another post.
It may prove a useful approach.
torachan.