Sub versus private/Public,etc.

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

Is there a problem or purpose in calling the start of a procedure with just
Sub instead of the Private/Public/Static Sub?
Rob
 
No. Default is Public so

Sub foo()

is equivalent to

Public Sub foo()


I like the latter simply because it makes the scope explicit.
 
So true and a clear answer. Thank you.
Rob

J.E. McGimpsey said:
No. Default is Public so

Sub foo()

is equivalent to

Public Sub foo()


I like the latter simply because it makes the scope explicit.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Private Sub Application_Startup()....What if it be public 1
Private Sub - Called from Userform 3
Private Sub - Only Accessible from same Module? 1
difference between a private sub and a public function? 4
how to disable Public function macro's 1
creating an excel add-in 6
Workbook-Close StopTimer event 2
loop through only public functions? 1

Back
Top