Variable Storage

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


Hello All,

Basically I have a form with a 'Save Data' cmdButton, when the user
clicks this they are prompted with a MsgBox (vbYesNo). If they say
'Yes' then I want to unload the form and then reload it again -
assuming this clears all the data inc. arrays. Before the form is
unloaded, I want to store some values on the form then put them BACK on
the form once its been reloaded.

I tried a global varaible declaration, but it'll only last as long as
the form - would the method be using the module to store/retrieve
varables? If so how wouyld i go by doing this?

Hope this makes sense to someone out there. Thanks in adavance for any
help!

Joe


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30634
View this thread: http://www.excelforum.com/showthread.php?threadid=509949

.

Relevant Pages

  • Re: Passing to and back from Dialog
    ... you don't even unload it until the data's been validated. ... That way you can make it visible again if the calling procedure has to do the validation and the validation check fails. ... You can unload the form and still access that property without causing the form to reload. ... They are cleared by setting the form's object variable to Nothing (or writing a method to clear or explicitly setting the property to a default value). ...
    (microsoft.public.vb.general.discussion)
  • Re: Using Form_KeyPress to quit
    ... referencing the form or a control on the form. ... reload the form, run the Form_Load event again, and then continue. ... When you decide to unload you also need to use 'Exit Sub' and/or set a flag ... If you put a breakpoint in your Form_Load routine then when it happens the ...
    (microsoft.public.vb.general.discussion)
  • Re: b43 locks the machine when resuming after suspend to disk
    ... I can unload the module ... before suspending, ... reload it after resuming, same result; ... That starts to sound like some core problem -- bug in b43 does not ...
    (Linux-Kernel)
  • Re: Form not unloading before next code line
    ... I have tried what you suggested and l still get the MsgBox before the frmHR ... Regards ... >> I have a large form which l need to unload before the MsgBox asks the ...
    (microsoft.public.excel.programming)
  • Re: Proper way to terminate a forms-based application
    ... associated with the form module remains in memory." ... If you don't want your second msgbox to appear then put 'Exit sub' after ... 'Unload me' ... Private Sub Command1_Click ...
    (microsoft.public.vb.general.discussion)