Sarah's VB.NET Playground

SarahRawlinson

1,938 views

GitHub

Open Source Your Knowledge, Become a Contributor

Technology knowledge has to be shared and made accessible for free. Join the movement.

Create Content

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

FOR

FOR EACH

Advanced usage

If you want a more complex example (external libraries, viewers...), see the official documentation.

Open Source Your Knowledge: become a Contributor and help others learn. Create New Content

Open Source Your Knowledge, Become a Contributor

Find my other projects on

- GitHub

- itch.io

- YouTube

VB.NET / VBA Basics

Advanced usage

PYTHON: BEGINNER QUIZ (10 Questions)

Stored Procedures con T-SQL

PYTHON STRING METHODS: center(), rjust() and ljust().

Online Voting Concept