Open Userform two ways
I've a userform that needs to be loaded in one of two scenarios ...
First, it may be used to MODIFY an existing entry ... so would be pre-
loaded using data passed from another userform.
Or, it could be used ADD a new entry ... so would be loaded with all
fields blank.
How do I tell the userform which way to load? I could test to see if
the other userform is loaded, but doing so would automatically load it
anyway, right?
Thoughts or ideas?
TIA,
Ray
|