Search notes:

VBA operators

VBA has two kinds of operators:

and

The and operator can be used to check whether a specific bit is set
option explicit

sub main()

    dim num as integer

    for num = 0 to 17

        if num and 4 then
           debug.print format$(num, "@@") & " : bit 4 set"
        else
           debug.print format$(num, "@@") & " : bit 4 not set"
        end if

    next num

end sub
Github repository about-VBA, path: /language/operators/and.bas

addressOf

The addressOf operator evaluates to the address of the name of the sub/function that follows it.
It is usually used for Win API callbacks.

like

like allows to perform text-pattern matching. It is still far from regular expressions.

Other operators

-
&
*
/
\
^
+
=
arithmetic
comparison
concatenation
eqv
imp
is
logical
mod
new
not
or
xor

See also

VBA.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740090034, '3.15.185.186', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/languages/VBA/language/operators/index(136): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78