IsNull Function

๋ณ€์ˆ˜๊ฐ€ ๋ฐ์ดํ„ฐ๋ฅผ ํฌํ•จํ•˜์ง€ ์•Š๋Š”๋‹ค๋Š” ๊ฒƒ์„ ๋‚˜ํƒ€๋‚ด๋Š” ํŠน์ˆ˜ํ•œ Null ๊ฐ’์ด Variant์— ํฌํ•จ๋˜์–ด ์žˆ๋Š”์ง€ ํ™•์ธํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ:

IsNull (Var)

๋ฐ˜ํ™˜ ๊ฐ’:

Bool

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

Var: ํ…Œ์ŠคํŠธํ•  ์ž„์˜์˜ ๋ณ€์ˆ˜์ž…๋‹ˆ๋‹ค. ์ด ํ•จ์ˆ˜๋Š” Variant์— Null ๊ฐ’์ด ํฌํ•จ๋œ ๊ฒฝ์šฐ True๋ฅผ, ๊ทธ๋ ‡์ง€ ์•Š์€ ๊ฒฝ์šฐ False๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

Null - ์œ ํšจํ•œ ๋‚ด์šฉ์ด ์—†๋Š” Variant ๋ฐ์ดํ„ฐ ํ•˜์œ„ ํ˜•์‹์— ์‚ฌ์šฉ๋˜๋Š” ๊ฐ’์ž…๋‹ˆ๋‹ค.

Error codes:

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

์˜ˆ:

Sub ExampleIsNull

Dim vVar As Variant

    MsgBox IsNull(vVar)

End Sub