Sum row cells value

[Jefferson]

I'm new to this. I need to randomly input values into row cells and when press enter key, it calculates the total value and show in another sheet. Example, in sheet1, I input random values in A1,C1,D1,Z1 and when I press enter key, it calculates the total value and appear in the first row cell, A1, of sheet2. All by VBA coding. Appreciate any help.

 

[grahamvb]

Excel cell formula
=Sum(A1+C1+D1+Z1)
Or
=Sum(A1:Z1)

VBA
Name cells or range and write VBA to sum them.