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

  1.
    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
  2. François
     
    Thank you, it works perfectly!!!

    See you!
    0