how do I express the term if x is integer in VBA language ? I want to write a code that does something if x is integer and does something else if its not with vba excel.
Sub dim() Dim x is Variant 'if x is integer Then 'Else: End Sub
If IsNumeric(x) Then 'it will check if x is a number
If you want to check the type, you could use
If TypeName(x) = "Integer" Then
This may suit:
If x = Int(x) Then
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With