Question

(VBA Coding Simple Questions) Please write the syntax for:

a) how to write a sub

b) a function

c) how to reference a given element in an array,

d) how to write the different types of loops (syntax) for next, do while, do until

e) format for a VBA If statement then

f) format for a VBA If statement then else

g) for generating a random value

h) setting the range

Answer 1

syntax for:

a) how to write a sub

sub subprocedureName()

end sub

b) a function

function functionName()

functionName=value 'to return value

End function

c) how to reference a given element in an array,

value = arrayName(indexNumber)

d) how to write the different types of loops (syntax) for next, do while, do until

1) for variable=initial value to final value

' statments

Next variable

2) Do While Condtion

'statements

Loop

3) Do Until Condtion

'Statements

Loop

e) format for a VBA If statement then

  

if(condtion) then

true statement

End if

f) format for a VBA If statement then else

if(condtion) then

true statement

else

false statement

End if

g) for generating a random value

Randomize

variable = Int(lowerbound+Rnd() * (upperbound - lowerbound + 1))

h) setting the range

dim variable as Range

Set variable = Range("ColumnNameInitial RowNumberInitial : ColumnNameFinal RowNumberFinal")