VBA Intro

[KishorKK]

Hi All,

In VBA why can't we write like this..? Where it is going wrong can some one explain me?

For Ex:

sub msgbox()
msgbox("Hello!!")
End Sub

Why it's not executing like this if write like sub title() it will execute but if i use the same string like 'msgbox in sub' it won't work pls explain? Thanks

Regards,
Kishor

 

[Hui]

Msgbox is a keyword as it is a VBA Function
Title isn't a function or keyword

I'd suggest

Sub msg_box()
  msgbox ("Hello!!")
End Sub

 

[shrivallabha]

There are keywords which shall not be used for naming sub-routines.

Refer rules here:
https://msdn.microsoft.com/en-us/library/office/gg264773.aspx

 

[KishorKK]

Thanks Hui Sir, and shrivallabha