Excel VBA InputBox and MsgBox Output
<p>I am working on a program in which the user will supply the information for the length of a wall in cell D3 and E3 from a InputBox prompt.</p>

<pre><code>Public Sub dimensionInput()

Dim wallWidth As Double 'Get Wall Width Input
wallWidth = Application.InputBox("Input Desired Secondary Containment Wall Width in Inches", "Wall Width", 1)
If wallWidth = False Then
    Exit Sub
Else
Application.Worksheets("Sheet1").Range("D3").Value = wallWidth
End If

Dim wallLen As Variant 'Get Wall Length Input
wallWidth = Application.InputBox("Input Desired Secondary Containment Wall Width in Inches", "Wall Width", 1)
If wallLen = False Then
    Exit Sub
Else
Application.Worksheets("Sheet1").Range("D3").Value = wallWidth
End If

End Sub
</code></pre>

<p>Once that is done there will be prompts for the radius, length, orientation, and offset. The values will be enter with a comma and a space e.g. N1, N2, N3, ... I am having a hard time writing the VBA macro to separate the inputs based on the comma and then enter then in the cells. All the entries should go in the respective column. 
E.G.</p>

<p>Rad: 40, 30, 26, 23, 24, 20 &lt;---Input by user</p>

<p>Len: 60, 40, 96, 82, 72, 48 &lt;---Input by user</p>

<p>Orient: H, H, V, V, V, V, H &lt;---Input by user</p>

<p>Offset: 2, 2, 4, 1, 2, 1    &lt;---Input by user</p>

<p>Then according to that VBA it will fill in the cells as shown below. </p>

<p>Any help is greatly appreciated!</p>

<p><a href="https://i.stack.imgur.com/DfB7M.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DfB7M.png" alt="Image of the problem"></a></p>