Yaslaw.Info

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

<const>
    version=1.0.3
    vdate=03.09.2018
    fname=udf_isnothing.bas
    ns=%NAMESPACE%
    fpath=/vba/functions
</const>
====== [VBA] isNothing() ======
Prüft ob allgemein etwas in einer Variable ist. Fast also mehrere mögliche Leerprüfungen zusammen

Die folgenden Variableninhalte geben TRUE zurück
  *Null
  *Empty
  *Nothing
  *Leerer String (getrimmt)
  *leerer Array/Collection/Dictionary
  *Nicht initializierter Array

==Version %%version%% %%vdate%%==
{{%%fname%%|Download %%fname%% (V-%%version%%)}}

===== Definition =====
<code>boolean = isNothing(object)
boolean = isNothing(vaule)</code>
<code vb>Public Function isNothing(ByRef iValue As Variant) As Boolean</code>
  ***iValue**  Variable die geprüft werden soll

=== Beispiele ====
<code vb>?isNothing(123)
False

?isNothing(array())
True

?isNothing(array(1,2,3))
False

?isNothing("    ")
True

?isNothing(new Collection)
True</code>

===== Code =====
<source '%%fpath%%/%%fname%%' vb>

Yaslaw.Info

User Tools

Site Tools

Page Tools