vba courses london - Brackets after the sub name

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Brackets after the sub name

Matt has attended:
Access VBA course

by - delegate Matt [1 post] (2007 May 30 Wed, 09:50) Reply

Hi,

Could you let me know what I should use the brackets for after the initial sub command?

ie. Sub ThisMacro()

I remember it is used to define something but also remember that it wasn't used in every case.

Thanks,
Matt

RE: Brackets after the sub name

by - trainer Richard platinum contributer [761 posts] (2007 Jun 8 Fri, 11:55) Reply

Hi Matt

The brakets are used to declare variables/arguments.

ie
Function sumNo(x, y)
sumNo = x + y
End Function

So in the above example, you would type in excel

=sumNo(3,5)

and the answer would be 8

Alternatively you could use cell references

=sumNo(A1,A2).

Regards

Richard

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips