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!