Post MBA I am working in Financial Services. Programming skills are, nevertheless, handy with excel and VBA. Again, just collating things that I looked for while solving problems. Not a VBA expert, so some ways may not be most efficient, but they work. For many things you can simply record a macro and play with it. For other tasks you have to do a bit of research.
To get string input:
Dim strInput As String
strInput = InputBox(Prompt:="Please input a value:", _
Title:="Box Title")
To get range input:
Dim inputRange As Range
On Error Resume Next 'needed in case user does not select
Set inputRange = Application.InputBox _
(Prompt:="Please select a range:", _
Title:="Select Range", _
Type:=8)
If inputRange Is Nothing Then
MsgBox ("No value selected")
Else
'do something
End If