Ask the user

K

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
 
C

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
 
Top