How to check if a number is positve integer in VBA?

[VAer]

I use IsNumeric to check if it is a number, then I will need to check if it is positive integer.

How to check if a number is positive integer or not?

Thanks.

[Greg M]

Hi there,

Enter the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

Use the function by entering "=IsPositiveInteger(B3)" in the required cell, where B3 is the address of the cell whose value you wish to test.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[VAer]

Thanks much.

[Akuini]

Just another option:

Please Login or Register  to view this content.

Test:

Please Login or Register  to view this content.

[Akuini]

Sorry, I should add "And x > 0" to the code in post #4:

Please Login or Register  to view this content.

[ByteMarks]

One for luck

Please Login or Register  to view this content.

[jindon]

Simply

Please Login or Register  to view this content.

Edit

positive integer

Exclude 0

[ByteMarks]

Even better!