Hi again,

Am Mon, 28 Sep 2015 01:42:03 -0700 (PDT) schrieb L. Howard:

What would be the proper way to manage errors for a multitude of input boxes entering Strings or Longs, boxes have OK, Cancel & Red "X".
or create a UserForm with seven TextBoxes and a CommandButton.
With a macro start the UserForm. With the CommandButton write the values
to the sheet. You can check the TextBoxes for length.

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional