Question : how to check is the value enterd is a number or text in vba
Answered by : arrogant-ant-cbr4cn3yoets
If IsNumeric(Value) = True Then MsgBox "The value is numeric"
Else MsgBox "The value is not numeric"
End If
Source : https://www.automateexcel.com/vba/isnumber-isnumeric/#:~:text=IsNumeric%20is%20the%20VBA%20function,or%20FALSE%20as%20a%20result.&text=In%20this%20example%2C%20we%20check,the%20result%20of%20the%20function. | Last Update : Tue, 07 Jul 20