IsNumeric Function

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

๊ตฌ๋ฌธ:

IsNumeric (Var)

๋ฐ˜ํ™˜ ๊ฐ’:

Bool

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

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

Error codes:

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

์˜ˆ:

Sub ExampleIsNumeric

Dim vVar As Variant

    vVar = "ABC"

    Print IsNumeric(vVar) REM Returns False

    vVar = "123"

    Print IsNumeric(vVar) REM Returns True

End Sub