On Wed, 16 Jul 2008 10:51:09 +0100, "Bob Phillips"
wrote:

Thanks for the tip Bob. I had actually never used that function
before, so it took me some time to figure out how to make it work.

I've shed the On Error statement now, and it works well. I guess when
you mentioned validation before I assumed you meant validating the
textBox input, and not validating the text.

Thanks again.

I would remove the On Error and when adding textbox values use

Val(TextBox1.Text) etc., that should handle empty textboxes