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
    I use a userform to imprt a text file and put data in sheet.
    Naturally thi operation use a mutch time to import.
    In the user form have buttons, option button.. ecc this elemet are used to make other operation.
    If the user click on button during the importing, sure the programm go in error!
    is possible to lock all elemnt during the import and unlock when the importing is finished?
    Other way are welcome...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could display another userform with a label that says "Please be patient" or something similar before starting the import, and close it when the import has finished:

    UserForm2.Show
    ...
    ' your code to import the text file
    ...
    Unload UserForm2

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='796748' date='07-Oct-2009 13:55']You could display another userform with a label that says "Please be patient" or something similar before starting the import, and close it when the import has finished:

    UserForm2.Show
    ...
    ' your code to import the text file
    ...
    Unload UserForm2[/quote]

    good idea!
    Simple but good. 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
  •