Sarah's VB.NET Playground

SarahRawlinson

1,688 views

Find my other projects on

- GitHub

- itch.io

- YouTube

VB.NET / VBA Basics

VB.NET & VBA are case insensitive meaning you can write functions & variables in lower case or upper case.

This means if we create a variable 'dim i as integer' we can also refer to this variable as 'I'.

VB.NET & VBA are similar but not the same, read more about the differences here

HELLO WORLD

What is the variable 'CONDITION' in the code above?

Integer

Double

Boolean

Long

ELSE

SELECT CASE

Imports System
Public Module modmain
   Sub Main()
        DIM VALUE AS STRING: VALUE = "RED"
        SELECT CASE VALUE
            CASE "GREEN"
                Console.WriteLine ("VALUE IS GREEN")
            CASE "YELLOW"
                Console.WriteLine ("VALUE IS YELLOW")
            CASE "RED"
                Console.WriteLine ("VALUE IS RED")
            CASE "BLUE"
                Console.WriteLine ("VALUE IS BLUE")
            CASE ELSE
                Console.WriteLine ("VALUE NOT THE DEFAULT COLOUR")
        END SELECT
        
   End Sub
End Module

WHILE

Imports System
Public Module modmain
   Sub Main()
        DIM NUMBER AS INTEGER: NUMBER = 10
        DIM COUNTER AS INTEGER: COUNTER = 1
        WHILE COUNTER <= NUMBER
            Console.WriteLine ("COUNTING - " & COUNTER)
            COUNTER = COUNTER + 1
        END WHILE 'in VBA this should be 'WEND' instead of 'END WHILE'
   End Sub
End Module