If you trying to fetch an Inputbox question and you want user to be restricted based on some type of question, you can set the following
InputBox(Prompt[,Title][,Default][,x][,y][,HelpFile][,HelpContextId][,Type])
where Type specifies the return data type:
Type Values | |
0 | Formula |
1 | Number |
2 | Text (String) |
4 | Logical value (True or False) |
8 | Cell reference (Range object) |
16 | Error value |
64 | Array of values |
Eg : Set address
Set rInput = Application.InputBox _
(Prompt:="Enter the Column Number Input Cell like R1 etc :", _
Title:="Row Input Cell", _
Type:=8)
sAddress = rInput.Address
