IsNumeric Function

์‹์ด ์ˆซ์ž์ธ์ง€ ํ…Œ์ŠคํŠธํ•ฉ๋‹ˆ๋‹ค. ์ด ํ•จ์ˆ˜๋Š” ์‹์ด ์ˆซ์ž์ธ ๊ฒฝ์šฐ True๋ฅผ, ๊ทธ๋ ‡์ง€ ์•Š์€ ๊ฒฝ์šฐ False๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ:


IsNumeric (Var)

๋ฐ˜ํ™˜ ๊ฐ’:

Boolean

๋งค๊ฐœ ๋ณ€์ˆ˜:

Var: ํ…Œ์ŠคํŠธํ•  ์ž„์˜์˜ ์‹์ž…๋‹ˆ๋‹ค.

Error codes:

5 ์ž˜๋ชป๋œ ํ”„๋กœ์‹œ์ € ํ˜ธ์ถœ์ž…๋‹ˆ๋‹ค.

์˜ˆ:


Sub ExampleIsNumeric
Dim vVar As Variant
    vVar = "ABC"
    Print IsNumeric(vVar) ' False
    vVar = "123"
    Print IsNumeric(vVar) ' True
End Sub

Please support us!