Search notes:

VBA statement: enum

select case

An enum is almost predestined to be used along with a select case statement.
' option explicit

enum META ' {
    FOO
    BAR
    BAZ
end enum ' }

sub main() ' {

    s1 BAR
    s1 2
    s1 5

end sub ' }

sub s1(m as META) ' {

    debug.print "m = " & m

    select case m
       case FOO : debug.print "foo"
       case BAR : debug.print "bar"
       case BAZ : debug.print "baz"
       case else: debug.print "?"
    end select

end sub ' }
'
' Output is:
'
' m = 1
' bar
' m = 2
' baz
' m = 5
' ?
Github repository about-VBA, path: /language/statements/enum/select.bas

See also

VBA statements

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...', 1758200858, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/languages/VBA/language/statements/enum/index(80): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78