Clarification on Procedure Declarations

M

Matt Weyland

Can anyone summarize or clarify the procedure declaration
options? I know about public and private. But I don't know
what Friend and Static are for.

Thanks
 
C

Chaplain Doug

Static when used to declare a variable, ensures that the
variable value remains the same when you return to the
procedure or function in which it is set. Static used to
declare a function or procedure ensures that ALL the
variables in the function or procedure retain their values
between calls.
 

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

converting VBA password-masking code to 64-bit 0
Declaring Variables 3
Declaration Questions 1
I'm John, My first post. 0
Insert Index into a Table 1
VBIDE.Codemodule.addfromfile putting code in wrong place 3
What is wrong with this? 4
Change textbox/combobox colors with a procedure 9

Top