Manage errors with multiple InPut Boxes
sorry for the delay. I was not at home.
Try:
Sub Inputbox_Comma()
Dim Empl_Info, i As Long
Dim myArr As Variant
Empl_Info = InputBox("Enter Employee Info, separated by commas")
myArr = Split(Empl_Info, ",")
With Sheets("Master")
.Cells(Rows.Count, 1).End(xlUp)(2) _
.Resize(columnsize:=UBound(myArr) + 1) = myArr
End With
End Sub
Regards
Claus B.
--
Perfect, as always!
Thanks.
Howard
|