I have a routine which inserts a new row for data input and then pops up an
inout box. Presently the input box is being used to populate one specific
cell in the new row. I have to add several new columns on the spreadsheet
and will have to use Inputbox to populate those cells as well. Is there a
way to have one Inputbox ask for three or four answers for the related cells?
I have included the current code below.

Title = Counterparty
msg1 = "Enter the counterparty type: "" c "" = customer, "" dm "" = dealer
macro hedge (portfolio hedge), "" dh "" = dealer hedge (for the above trade),
"" i "" = internal Your entry will be placed in a column to the right
labeled, ""Counterparty"""
Custdlrint = InputBox(msg1, Title, Default, 15, 15)
If Custdlrint = Cancel Then
Exit Sub
Else
End If


Thanks,

Jim