View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
 
Posts: 267
Default 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