Re: UserForm Data Validation. I tried and tried but can't figure it out.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Helmut,

Here is what Steve said about load and unload:

"Finally, I did some pretty exhaustive testing, and asked around inside, and
found that effectively:
Unload MyForm is the same as Set MyForm=Nothing
and
Load MyForm is the same as Set MyForm = New DINGOFORM1
Load and Unload are only there for magic forms support, as in
Load DINGOFORM1"

I don't know what he means by "magic forms support."

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

Helmut Weber wrote:
> Hi submariner,
>
>> It seems to work (I couldn't break it).
>> As you said, "no objects, no
>> global variables required, seemably."
>
>> What I don't know is if I have created robust code or a time bomb.
>
> I don't know either and would like to hear from the co-readers,
> if I have to load a form and unload it afterwards,
> and how, to avoid all possible complications.


.

Relevant Pages

  • Re: restart application
    ... Unload the old ones, ... then would mean one could not use the build in support ... for linking to LIBS. ...
    (alt.comp.lang.borland-delphi)
  • Re: UserForm Data Validation. I tried and tried but cant figure it out.
    ... Dim UserForm1 As New UserForm1 ... Which declares (and tells VBA to load on first use) an object variable, ... Dim myForm As New UserForm1 ... This post seems to be quite long enough so I'll leave Unload / Set to ...
    (microsoft.public.word.vba.general)
  • Re: UserForm Is A Class
    ... assume the using "Load" is the correct in a situation like your example. ... Load myForm ... > Private Sub UserForm_Activate ... > Private Sub UserForm_Deactivate ...
    (microsoft.public.word.vba.general)
  • Re: Poser? What happens to empty pages in a database unload/load?
    ... At my company, several time each weekend, a database is unloaded at ... squeezed out of the load. ... I unload the table and load it back and now all those empty pages are ... Art S. Kagel ...
    (comp.databases.informix)
  • Re: Seltsames Problem mit Form.release
    ... Geht das auch im Load? ... Und passend zum allerersten Even Loadkommt als letztes Unload. ... deren erstes Event Initund letztes Event Destroy() ist. ... QueryUnload() ...
    (microsoft.public.de.fox)