Auto Calculation in "Amount" column when u enter rate & Qty

Hey!

I am using purchase entry in excel user form. when i am entering the data
i need to have the amount column to calculate Amount automatically when i enter rate and quantity. So the rate & Qty should be in multiply mode.

I try to place it by recording macro but i failed. Can U help me?

Regards
Charles