Autofill Formula upon data entry

I am new to the forum and no VBA expert but am learning. Hello all.

I need a procedure that autofills a formula down when the user enters data in a row. For example suppose I have the following data, where column E contains a formula that multiplies the values accross row of entered data:

A B C D E
1 Product X 2 5 8 =2*5*8
2 Product Y 5 8 1 ???????

I need to write a procedure that says, "if there is text in any cell in Column A, then column E needs to execute the formula. So if the user enters any text in A2, then E2 automatically calculates B2*C2*D2.

Any help much appreciated,

Bob B

Here you BOB,
I have attached a sample file, offering to your problem. let me know if it goes for you.
stay blessed

Thank you for your response,

This code results in the following error which I am not familiar with.

Compile error:

Ambiguous name detected: Worksheet_Change


I have another Worksheet_Change procedure in the VBA module and I suspect it has something to do with this?

I got it!

Thanks everyone much appreciated.

Bob B