Can´t open the Form(Application defined or object error)

KhallP

Board Regular
Joined
Mar 30, 2021
Messages
157
Office Version
  1. 2016
Platform
  1. Windows
When I try to open the Form I get an error ("Application defined or object error"), can someone help me?


VBA Code:
lb_erro_email.Visible = False
lb_erro_confirmar_email.Visible = False
lb_confirmar_checkboxes.Visible = False

Select Case True
    
Case Trim(tb_email) = "" And Trim(tb_confirmar_email) = ""
    lb_erro_email.Visible = True
    lb_erro_confirmar_email.Visible = True
    
    
Case Trim(tb_email) = ""
    lb_erro_email.Visible = True
    
    
Case Trim(tb_confirmar_email) = ""
    lb_erro_confirmar_email.Visible = True
    
    
Case tb_email <> tb_confirmar_email
        lb_erro_confirmar_email.Visible = True
        lb_erro_confirmar_email.Caption = "Os E-mails não correspondem"

Case Else

    If cb_confirmar_credenciais = False Or cb_receber_email = False Then
        lb_confirmar_checkboxes.Visible = True
        
    Else
        email = tb_email.Value
        Unload Me
        Registar_Complete.Show
        
    End If
    
End Select
End Sub

app.JPG


app_2.JPG
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
there is most likely an unknown object on the next userform Registar_Complete. you are looking in the wrong code i think
 
Upvote 0

Forum statistics

Threads
1,223,902
Messages
6,175,278
Members
452,629
Latest member
SahilPolekar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top