Multiplication hidden in column

[manufacture1]

Hello guys.
I have little problem.
I am starting in VBA and i am trying to make macro.
There is column A and B. In A i write number and then in B it should automatlicy give me multiplication that i wrote in macro and then it shows me result of multiplication.
Can someone help me??

[:) Sixthsense :)]

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

[NeedForExcel]

You can have a simple Function like -

Please Login or Register  to view this content.

And you can use this in the Excel Sheet as mentioned below.

It will multiply the Value of Cell A1 by 3 -

=Multiply(A1,3)

[:) Sixthsense :)]

You can have a simple Function like - =Multiply(A1,3)

Dave why not =A1*3 ??

[manufacture1]

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

Sory but not working

[NeedForExcel]

Dave why not =A1*3 ??

So that he has an option to select any Cell for multiplication he wants..

[:) Sixthsense :)]

So that he has an option to select any Cell for multiplication he wants..

Sorry, I am not getting your point

[:) Sixthsense :)]

Sory but not working

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[NeedForExcel]

Sorry, I am not getting your point

Oh so you are asking, why not use a simple calculation rather than VBA?

That is because manufacture1 mentioned he is new to VBA and would like to learn it..

[:) Sixthsense :)]

Oh so you are asking, why not use a simple calculation rather than VBA?

Yes, exactly

That is because manufacture1 mentioned he is new to VBA and would like to learn it..

Oopss... I missed that point Thanks for the clarification