Blog Archives

Gather User Data/Input via an InputBox

There are many times in Excel VBA that we are required to gather information from a user. Probably the most frequent method of doing is via a message box, that is; Sub UserInput() Dim iReply As Integer iReply = MsgBox(Prompt:="Do

Posted in VBA Snippets Tagged with: , , , , , , , ,