Converting simple multiplication formula in VBA code

**Saky** · 12-06-2010, 09:25 AM

Friends,

I need a macro coding where i need to multiply the values entered in col G and Col M should get multiplied and reflect the result in column O.

I tried to do this in VBA coding but unfortunately i could not make it...Here is my code.

Can anyone help me to modify it.

Please Login or Register  to view this content.

**Marcol** · 12-06-2010, 09:33 AM

Try this

Please Login or Register  to view this content.

Hope this helps

**Saky** · 12-06-2010, 10:39 AM

Originally Posted by Marcol

Try this

Please Login or Register  to view this content.

Hope this helps

Thank you Marcol!!! This code works great.

Adding to that i need a result in col Q where it should divide the value in Column O by 540*60. I need the result without decimals hence i have added Round function.

The below code works fine, but the issue is this coding works only if there is any action in col O. How can i solve this issue.

I want the result to reflect automatically as it is reflecting in Col O. If it cannot be able to work automatically can it be done by clicking the cell(click event)..just a suggestion from my end...

Kindly help...

Please Login or Register  to view this content.

**Marcol** · 12-06-2010, 11:11 AM

This should work as you ask

Please Login or Register  to view this content.

There seems to be nothing wrong with your additional code, just remember that the result in Column O has to be about 19440 to get a result of 1 in Column Q when you use round to zero decimal places.

What is the context of this?
What are you trying to do is it something to do with times?

**Saky** · 12-06-2010, 11:32 AM

Marcol,

As you said the additional code works fine..But the problem is

Only after pressing F2 in col O3 only then i am getting the result in Q3.

So this macro is starting its function only when any action is performed in the targeted cell.

I am asking without doing that action can i get the result automatically in Column Q.

**Marcol** · 12-06-2010, 11:43 AM

Try this, Column O will update when either Column G or M is changed for that particular row

Please Login or Register  to view this content.

Is that what you are after?

**Marcol** · 12-06-2010, 11:53 AM

Why do you need vba for this?

in Column O

Please Login or Register  to view this content.

Drag/Fill Down

in Column Q

Please Login or Register  to view this content.

Drag/Fill Down

**Saky** · 12-07-2010, 07:33 AM

Marcol,

Thank you so much for your assistance. With some more tweaking in the macro code you have provided i got the result what i expected. Thanks again...