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.

	A	B1	C	D	E	F	G
1	material	Desc.	Cube	Lbs	Sun	Mon	Tues
2	XYZ	Material	190	18		5600
3	ABC	Material	656	4.375			1000
4
5

<tbody>
</tbody>

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!