Userforms,a need to unload?

[Cerebum]

I have created a workbook with quite a few userforms. Most of the userforms have listboxes. This is the first time I have really worked with them. The computers we have at work are not great but I have been having memory issues and was wondering if it is necessary to add code so that userforms/list boxes don't stay active after use.
I am using the code below to call the userform and generally using the "X" on the userform to exit. Should I add an Unload Me?

Sub Trunklinkform1()
UserForm12.Show
End Sub

Cheers guys

 

[RoryA]

If you close using the X that should unload the form.
Do you have forms calling other forms?

 

[Cerebum]

No, all the userforms are separate. I also assigned macros to command buttons rather than list box clicks just in case (paranoid ) what made me wonder was the fact that the list box in the userform appears with the previously selected option still highlighted. I was not sure if it was attempting to access it constantly or if it just happened to be selected.

 

[RoryA]

Are the listboxes linked to cells on worksheets using the ControlSource property, or are you assigning them a value in code when you load the form? If so, you would see a preselected item. If not, I'd suspect you are perhaps hiding the form rather than unloading it (which would involve code in the QueryClose event if you close by clicking the form X)

 

[Cerebum]

I didn't add any code, just slapped the list box in and linked it to cells in the "RowSource" & "ControlSource" boxes. Would it be an easy out to just stick a command button on eack one linked to "Unload Me"

 

[RoryA]

The controlsource is why you are seeing items selected - whatever value is in the linked cell is the selected value in the listbox.

 

[Cerebum]

Something interesting happened. I ran some code that clears some of the core data and each userform that links to the data appeared one after another in the VBA window! Any ideas how I stop this

 

[RoryA]

Don't bind the controls to the sheets or close the vbe while running the code.

 

[Cerebum]

Thanks for your help. All seems to be fine now

Kind Regards

Peter