Hi , 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
views:
497answers:
3
+4
A:
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
shahkalpesh
2010-01-02 21:35:03
ok thanks , btw onaside how do I add code tags?
excel34
2010-01-02 22:11:36
You can either click the button in the editor that looks like 1s and 0s, or you can use nest your code in <pre> tags and then <code> tags. (You must do both). It's generally better to paste the code, highlight it, then click the button. But the editor can be finicky and sometimes it's less hassle to just manually put in the tags.
Oorang
2010-01-03 06:30:35