The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Brackets after the sub name

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba courses london - Brackets after the sub name

Resolved · Low Priority · Version Standard

ReplyWed 30 May 2007, 09:50Delegate Matt said...

Brackets after the sub name

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

For upcoming training course dates see: Pricing & availability

ReplyFri 8 Jun 2007, 11:55Trainer Richard said...

RE: Brackets after the sub name

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

VBA articles

· It Pays To Learn To Speak The VBA Language
· VBA With Excel - Making The Working Day That Little Bit Easier
· Stay In The Loop With VBA
· OOPS Visual Basic Did It Again
· Make Office work for you with VBA

Vba tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips

How do I consolidate data?

» Forum post: Data cosolidating

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions