Ask the user

[keyser_Soze]

I need to get some data from the user. I need a string and a yes/no
answer.

I can use inputbox to get the string. What methods are there to get a
yes/no?

I would really like both an input box for the string and a checkbox on
the same popup. Is that possible?

Thanks

 

[Chip Pearson]

You can use a simply MsgBox to ask the user a yes/no question.
E.g.,

Dim Res As Long
Res = MsgBox("Yes or no", vbYesNo)
If Res = vbYes Then
' user click yes
Else
' user click no
End If

See VBA Help for MsgBox for more info.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com