Surely you just enter in D1

=A1*B1

Or would this link help

http://www.j-walk.com/ss/excel/tips/tip43.htm

VBA Noob