View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adrian[_7_] Adrian[_7_] is offline
external usenet poster
 
Posts: 29
Default Initializing static variables in VBA

Hi,

I am writing a static procedure as follows:

Sub Test

call Counter
call Counter
call Counter

End


Sub Counter()

Static counter as Integer

counter = counter + 1

Debug.print x

End Sub

I want to print a series of numbers 12,13,14, from the
test procedure instead of 1,2,3 . How do i go about doing it ?
In other words, how do i initialize a static variable in a Sub procedure ?

Thanks.

--
Regards,
Adrian