without looking at it too closely... just reading it...
You can't define a public Dim. If you want it global you have to use Public
at the top of the module.

I may be totally wrong and am looking at it now.