Hi Howard,

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".

Click OK with no entry produces Type Mismatch, as does Cancel. Or one could enter text in a Long Dimmed input box.

Does it make sense to have a "On Error GoTo" for each input box to go back to the same box with a MsgBox prompt?

use an Application.InputBox. With this box you can define the type of
data.
Your normal InputBox always return text.So you get an error if declared
as long.
What about all inputs in one InputBox comma separated. And then change
that string to an array and work with this array?


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