Q:

In Excel, can you create a cell that updates the number of another cell without having to hold the inputted value?

Since I can't create a form using VB or ACCESS here at work, I'm trying to figure out if I can use a cell as a makeshift form.  I want to label one cell "Enter New Order Quantity."  Next to it(next cell), I want the user to be able to input a number, have that number update two other cells, and then have that change stick, so that another number can be entered and added on top of the previous number in the aforementioned cells.  Is this possible?

A:

Add an ActiveX textbox (Developer tab, Controls section, 'Insert' button. default name is TextBox1).
Add a basic form control button (default name should be Button1)
Select button and click "View Code" in the same Controls section on toolbar
Then the sub should look something like this
Sub Button1_Click()
    Sheet1.Range("C1").Value = Sheet1.Range("C1").Value + Sheet1.TextBox1.Text
    Sheet1.Range("D1").Value = Sheet1.Range("D1").Value + Sheet1.TextBox1.Text
    Sheet1.TextBox1.Text = ""
End Sub

C1 and D1 would be the cells you wanted to copy the quantity to
Edit: Forgot the bit about clearing out the textbox.  And on a sidenote, Alt+F11 is a fast way back to the code window.

