User input Auto multiplies by constant

Hi,
Heres the situation that I have been hitting my head on. I need to create three columns that if a user inputs a number, it automatically multiplies by that number by a cell reference. So if a user types in 3 in column A Row 3, it automatically mutiplies that number by cell reference $A$2.
Thanks for the help!
-Vik

So if a user types in 3 in column A Row 3, it automatically mutiplies that number by cell reference $A$2.

You cannot type a number into a cell and at the same time multiply it by a number in another cell without using VBA or having a formula cell that uses two input cells.

Perhaps you meant: multiply $A$2 by a number entered into A3? If so, then
the results cell uses this formula: = $A$2*A3

I tried that code and followed your instructions to the letter, but it came back with a run time error 424.

Option Explicit

Please Login or Register  to view this content.

vikhound,

Obviously, disregard my post. For some reason, I must have thought I was in the General section of the forum.

Clearly, you intended to get a VBA solution.

Ok so I attached the file to this forum reply. Just to resummarize;
In this file I need to create reference cells with fixed values into C2, D2, and E2 respectively. Then I want the user to be able to enter values into the corresponding columns (C5, D5, or E5 onwards) and have it automatically multiply by C2, D2, or E2. So if a user wants to edit the RAD ingredient in product C, all they do is input a number into the corresponding column C and it automatically multiplies by the value in C2. Also, Can you tell me how to increase the number of columns in case new ingredients need to be added?
Thanks alot for taking trouble,
Vik