VBA: how to test inputbox value is a text or value ?

[mrchonginhk]

VBA: how to test inputbox value is a text or value ?

 

[Colo]

You can use IsNumeric function to test.
IsNumeric function returns True if it's value.

Dim var
var = InputBox("input something")
MsgBox IsNumeric(var)