View original (French)

Equivalent of the TEXT function in VBA

Solved
François -  
 François -
Hello,

I'm looking for the equivalent of the functions istext() and isnumber() for VBA...

Help me

Thank you
Configuration: Windows Vista Internet Explorer 7.0

2 answers

Answer 1 / 2
Polux31 Posted messages 7219 Status Member 1 204
 
Hello,

For estnum(), you have IsNumeric() and for esttexte() you have Not IsNumeric() .... ^^

;o)
--
“What is well conceived can be clearly stated, and the words to say it come easily.”
Nicolas Boileau
0
Answer 2 / 2
François
 
Thank you, it works perfectly!!!

See you!
0