resuming a routine after a userform

[cinziorecoaro]

Hi everyone,

I have a problem with VBA in Excel 2003. In a workbook I have many routines that they call an userform called “RichiediPwd”. In the routines code I have put:

Sub (routinename)
….
RichiediPwd.Show
….

The userform simply ask for a password and it determinates if the password is correct or not.
I wish if the password is correct the routine that previously called the userform resume from the point where it remained. Is there a way to do it?

At the present when the userform ok button code finishes all macro stop.

Please help me

 

[eddvrs]

Hey,

I do something similar... on the user form i have a textbox for username and another text box for password. I assume your is similar. it's caled from this procedure:

Sub ftp_login_details()
       
    With frm_ftp_pwd
        .show
        
        my_shortcode = LCase(.txt_ftp_username)
        my_pwd = .txt_ftp_password.Value

    End With

End Sub

then the password form has a command button with the following code:

frm_ftp_pwd.hide

Try something like that and see if it works