Offset from new name based on what's checked in Userform
Tom Ogilvy wrote
when you show the userform, the code stops execution until the
userform is hidden. Code not in the userform module must be qualified
with the userform name. Using WITH makes this much more compact.
I like it. Thanks.
I mistakenly thought that my cmdDone_Click line Me.Hide in the userform
module accomplished that.
Added bonus: the modified/compacted 'Set rng = ...' line. I'll incorporate
it in similar Add_Member modules in other workbooks.
--
David
|