Jindon,

The suggestions worked great, the message box displays everything.

Now i tried to capture what the user may have changed, for this i created another sub routine that is called just before the user form selections are placed onto the worksheet. See below, this is not the entire variables i truncated them for ease of discussion and only show 1 thru 6.

I tried to declare the myVerify as both String and Variant but neither worked. I though that the values that the user slected through the combo and text boxes would be still available to place into an array being that i called this sub routine within the initial sub routine, any thoughts?


Sub Verify()

Dim myVerify(1 To 40) As String


    myVerify1 = txtPlanningNo
    myVerify2 = cboEngineer
    myVerify3 = txtPartNo
    myVerify4 = txtPartDesc
    myVerify5 = txtDrawingNo
    myVerify6 = txtDrawingRev

For c = 1 To 40
Msg = Msg & vbNewLine & myVerify(c)
Next

MsgBox Msg


End Sub