Thread: What do [brackets] mean in VBA?

Hi all

I get the impression that the use of brackets [such as this] in VBA code is shorthand to produce the same compiled effect as an alternative more verbose (but possibly to me easier to understand) coding.
Example

Code:

Private Sub UserForm_Initialize()
    Me.ComboBox1.List = [MyArray]
End Sub

Could someone please re-write the above code without using the bracketed syntax, just so that I can understand the effect of that syntax?

Thanks

The brackets are a shortcut to the VBA Evaluate function. They look nice and compact, but when Evaluate is not needed, just add a function where none is necessary.

Code:

Me.ComboBox1.List = Range("MyArray").Value