Typically, I will get user input from comboboxes. MsgBoxes are either yes or no responses. You could ask a series of yes no questions and store the answers in variables. The best way would be to store the answer to the Msgbox in an integer but you could store it in a string variable or variant type also.
Here is an example of a MsgBox that would get user input and store it in a variable named "Response2" you could have Response1, Response2, Response36, etc.
Code:
Dim Msg2, Style2, Title2, Response2 'Make some declarations
Msg2 = " Access wants to know the answer. Is it Yes or No? " 'Define message
Style2 = vbYesNo + vbInformation + vbDefaultButton1 ' Define buttons.
Title2 = "Question" ' Define title.
Response2 = MsgBox(Msg2, Style2, Title2) 'This is where the message box pops up for the user
'Now you need to handle the user input
'The user has two options in this case
'Yes or No. We will handle the input with an
'If Then Else statement
If Response2 = vbYes Then ' User chose Yes.
MsgBox "Congratulations, you chose Yes. "
Else
MsgBox "You chose No. Goodbye! ", vbInformation, "Action Stopped"
Exit Sub
End If