Thread: Excel VBA guru please

Once you have 'unloaded' an object (ie fmCopy_Rows) you have completely removed it from memory. You just can't get it back by 'showing' it. Check out the 'load' statement documentation.

I think that might be your problem.

Thank Ferret. Made some mods but it still doesn't work.

In my module I "show vbModeless" the Copy form which loads it.

fmCopy_Rows.Show vbModeless

In the Copy form in the Help_Click code I hide the Copy form and Show (load) the Help form:
Private Sub cbHelp_Click()
fmCopy_Rows.Hide
fmHelp.Show
End Sub

In the Help form in the Close_Click code I unload the Help form and go back to module code.
Private Sub cbClose_Click()
Unload fmHelp
Copy_Rows 'Calls the original sub
End Sub

This seems to work ok when I step through the code (F8) but not when I run it.

I closed Excel and restarted. The code works perfectly now.

Thanks Ferret.

Just a comment on what you are doing and maybe it does not matter to your particular application if it is relatively small but if you are hiding 'frmCopy_Row' then later calling 'Copy_Rows'(which I assume creates, load the object 'frmCopy_Row' into memory then shows it) then you are creating multiple instances of that object.

ie you have 1 instance of frmCopy_Row in memory but hidden from view then you create another instance of it when you call 'Copy_Rows' again just before returning from cbClose_Click. You now have 2 instances of frmCopy_Row one of which is occupying memory but can no longer be accessed.

Repeat this several times and you have the makings of a 'memory leak'.

Thanks Ferret, but the Copy_Rows code only Shows the form. My understanding of Show is that if the form is not already loaded, Show will load it the first time.

Cheers.