Multiply Input Cell by Another Cell

[menglish]

Hi There,

I'm trying to multiply a cell within a table that I would input a number into by another cell and struggling with the VBA formula.

For example, I would input 5600 into F2 and want it to multiply by D2 and display the result within F2.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B1[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]material[/TD]
[TD]Desc.[/TD]
[TD]Cube[/TD]
[TD]Lbs[/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tues[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]XYZ[/TD]
[TD]Material[/TD]
[TD]190[/TD]
[TD]18[/TD]
[TD][/TD]
[TD]5600[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]ABC[/TD]
[TD]Material[/TD]
[TD]656[/TD]
[TD]4.375[/TD]
[TD][/TD]
[TD][/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thanks,

Matt

 

[Fluff]

I think Fluff might have forgotten one important part to his code (or else you might caught in an infinite loop).

Oops
Thanks for picking that up Joe.

 

[Joe4]

Thanks for picking that up Joe.

You are welcome.
I admit, I missed that too when I first glanced at your solution. It was only when I was drawing up the step-by-step instructions that I noticed that.

Well, it was a good demonstration on why it is sometimes necessary to disable events anyway!