View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tetsuya Oguma Tetsuya Oguma is offline
external usenet poster
 
Posts: 19
Default The way to make a Class and a Collection static

Hi All,

1. How can I preserve a instanciated class even after a macro finishs
executing. I do not want to run the same routine again and again if we can
keep a class previoulsy instanciated and some data in it.

2. I was thinking of making a Collection static, but when I declare it as a
module-level variable an "Invalid outside Procedure" error gets thrown... How
should I achieve this?

Thanks,
Tetsuya Oguma, Singapore