I am using variables and placing them into the hidden worksheet when the form is closed.

I guess I am basically doing as you suggest, other than I am not using collections - yet...

Learning by trial and error and the advice from all of the helpful MVPs.

I hope I speak for many of the people posting questions when I say you people are absolutely tremendous to help us all!