Table in a user form, but i want the user to enter a number into all cells

[TABLE="width: 500"]

[tr]

[td]

ITEM

[/td]

[td]

Price(Please enter Price)

[/td]

[/tr]

[tr]

[td]

Windows

[/td]

[td][/td]

[/tr]

[tr]

[td]

Doors

[/td]

[td][/td]

[/tr]

[tr]

[td]

Brush

[/td]

[td][/td]

[/tr]

[tr]

[TD="align: center"]TOTAL[/TD]

[td][/td]

[/tr]

[/TABLE]

Given the above table, i am looking for a way for the Total to sum given the inputted information above the price, but if one of the cells is left blank i want a message to appear "Please enter relevant information into ALL cells".

Any Ideas, is this even possible. i was trying something along the lines of conditional formatting but have yet to get it working correctly.

Re: Table in a user form, but i want the user to enter a number into all cells

Works a treat,

Thanking you LukeM