lock all elements of userform

Topic

New Reply

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…

Reply | Quote

Replies

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

Reply | Quote

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

good idea!
Simple but good. tks.

Reply | Quote