Public Variable and Static Variable Difference

As far as I understand from the book;

Public Variables apply for all modules in a workbook and they are presented with "Public" keyword.

However static variables are also apply for all modules in a workbook.

1) So what's the difference?

2) How are Static Variables presented?

Static variables are defined in a procedure/function and will retain their values between executions of that function or procedure - You cannot declare a static variable outside a sub, in the General Declarations section for example, so not sure about that "static variables are also apply for all modules in a workbook"

1) Then what's the difference between Static Variables and Local Variables?

2) How are Static Variables declared?

Originally Posted by hemesh

A local or procedure level variable is declared inside an individual procedure is not visible to any subroutine other than where it is declared
Static variables are declared using Static keyword
a local variable looses its value when the procedures is over but static variable preserve its value even when the procedure is comppleted means a static variable can hold the value till module is active and they can be declared at procedure level only

1) So, this means a Static Variable can be used in other procedures in a module as well, right?

2) Are a Static Variable declared before the first procedure in a module?

1. No, static variables are used only in the sub/function they are used.
2. No

I think that mikes post explains this pretty well