how do I express the term if x is integer in VBA language?

vba vb6
excel34 picture excel34 · Jan 2, 2010 · Viewed 72k times · Source

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

Answer

shahkalpesh picture shahkalpesh · Jan 2, 2010 
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

Related questions

Does VBA have Dictionary Structure?

Does VBA have dictionary structure? Like key<>value array?

Read More
VBA array sort function?

I'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other sort algorithm other than bubble or merge would suffice. Please note that this is to work with MS Project 2003, so should …

Read More
What is the difference between dim and set in vba

Pardon me as am a newbie in VBA. Sometimes I use Dim r as Range r = Range("A1") Other times I use Set r = Range("A1") What is the difference? And when should I use what?

Read More