how to know Application.InputBox value vba excel code example
Example: input box type vba
'0 A formula
'1 A number
'2 Text (a string)
'4 A logical value (True or False)
'8 A cell reference, as a Range object
'16 An error value, such as #N/A
'64 An array of values