Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    dubt to call userform (2000)

    in a project of my friuend i have see the code here:
    Option Explicit

    Sub MostraForm()
    Load frmImportaDati
    frmImportaDati.Show

    End Sub

    ... before to call the userform my friend use also: Load frmImportaDati

    but is required this statement?, or i can call the user form only with: frmImportaDati.Show


    clear me, please.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: dubt to call userform (2000)

    Load puts the userform in memory, so it can be manipulated with code, but does not SHOW the object (it will not be visible)

    Show will load in memory and then display the object.

    It is not neccessary to load before showing, though if the initiation code of the form is extensive it may make the transition cleaner.

    Steve

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dubt to call userform (2000)

    WOW! Good explain...
    tks.

Posting Permissions

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