Thread: Variables
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike NG Mike NG is offline
external usenet poster
 
Posts: 87
Default Variables

On Thu, 2 Jun 2005 at 12:23:28, Rob Bovey (Rob Bovey
) wrote:
Hi Mike,

If you declare your variable in the declarations section at the top of
the code module outside of any specific procedure that variable will hold
its value between button clicks.

Sorry me being stupid. I was already doing this, but I guessed some
sort of unexpected end of execution must have happened, cos last time I
debugged this it didn't seem to be happening
--
Mike