Results 1 to 2 of 2

Thread: Unload.Me Function

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    May 2004
    Location
    Right here
    Posts
    275

    Unload.Me Function

    I've seen rerefernce to the VBA function Unload.Me but I'm unsure what this does. I am guessing that it's a generic command for unloading userforms, so that you don't have to use a specific reference to the name of the userform (dialog box) that is currently active if you want to unload it.

    E.g. if you have two userforms that were created from a template, you could have on the template a Cancel button and just have the same code for all copies of that templete e.g. have Unload.Me as the event handler code for all subsequent Cancel buttons.

    Is this how the Unload.Me function works or am I barking up the wrong tree here?

    Cheers
    -Rob

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Unload.Me Function

    The Unload statement is for unloading forms and objects from memory just
    like you thought. The syntax is just like it is in VB - Unload Me.

    HTH
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width