11-24-2023, 11:07 PM
(11-24-2023, 11:02 PM)PhilOfPerth Wrote: OK. got it. Thanks for the clarification.I think you'll find your code easier to manage if you do this. There's nothing wrong however with making all your variables global with DIM SHARED if that is easier for you.
A problem not shared is a problem solved, to paraphrase an old saying.
I'll use the Dim Shared, and limit it to subs unless needed everywhere, as Terry suggested.