XLS Padlock Guide
XLS Padlock Guide

Indexes

 

 

VBA Code Protection > Supported VBA syntax by compiler > Indexes

 

Strings, arrays and array properties can be indexed using "[" and "]" chars. For example, if Str is a string variable, the expression Str[3] returns the third character in the string denoted by Str, while Str[I + 1] returns the character immediately after the one indexed by I.

 

More examples:

 

MyChar = MyStr[2]
MyStr[1] = "A"
MyArray[1,2] = 1530

 

Arrays