Tengo un userform para insertar/modificar/borrar datos en una tabla. El problema surge cuando intento editar o modificar parte de los datos, pero no me realiza ninguna accion o me da error.
Sub EditCrew()
Dim UltFila As Long, rango As String, FilaRegistro As Long, ans As Integer
If Len(frmCrew.TxtPassport) = 0 Then
MsgBox "Write True Passport", vbExclamation, "BALEARIA"
Exit Sub
End If
FilaRegistro = filaexisteregistro(frmCrew.TxtPassport, rango)
If FilaRegistro = 0 Then
MsgBox "ID don´t exist", vbExclamation, "BALEARIA"
Exit Sub
End If
Tengo un userform para insertar/modificar/borrar datos en una tabla. El problema surge cuando intento editar o modificar parte de los datos, pero no me realiza ninguna accion o me da error.
Sub EditCrew()
Dim UltFila As Long, rango As String, FilaRegistro As Long, ans As Integer
Sheet5.Visible = True
Sheet5.Unprotect ("xxxx")
UltFila = Range("A" & Rows.Count).End(xlUp).Row
rango = "A2:A" & UltFila
If Len(frmCrew.TxtPassport) = 0 Then
MsgBox "Write True Passport", vbExclamation, "BALEARIA"
Exit Sub
End If
FilaRegistro = filaexisteregistro(frmCrew.TxtPassport, rango)
If FilaRegistro = 0 Then
MsgBox "ID don´t exist", vbExclamation, "BALEARIA"
Exit Sub
End If
Sheet5.Cells(FilaRegistro, 2) = frmCrew.TxtPassport
Sheet5.Cells(FilaRegistro, 3) = frmCrew.TxtName
Sheet5.Cells(FilaRegistro, 4) = frmCrew.TxtSurname
Sheet5.Cells(FilaRegistro, 5) = frmCrew.ComboRank
Sheet5.Cells(FilaRegistro, 6) = frmCrew.TxtNationality
Sheet5.Cells(FilaRegistro, 7) = frmCrew.TxtBirth
Sheet5.Cells(FilaRegistro, 8) = frmCrew.TxtPlace
Sheet5.Cells(FilaRegistro, 9) = frmCrew.TxtSeamanbook
Sheet5.Cells(FilaRegistro, 10) = frmCrew.TxtVISA
Sheet5.Cells(FilaRegistro, 11) = frmCrew.TxtCAD
Sheet5.Cells(FilaRegistro, 12) = frmCrew.TxtGENDER
Sheet5.Cells(FilaRegistro, 12) = frmCrew.TxtCompetency
Sheet5.Cells(FilaRegistro, 13) = frmCrew.TxtBasic
Sheet5.Cells(FilaRegistro, 14) = frmCrew.TxtPax
Sheet5.Cells(FilaRegistro, 15) = frmCrew.TxtCraft
Sheet5.Cells(FilaRegistro, 16) = frmCrew.TxtFire
Sheet5.Cells(FilaRegistro, 17) = frmCrew.TxtFRB
Sheet5.Cells(FilaRegistro, 18) = frmCrew.TxtAid
Sheet5.Cells(FilaRegistro, 19) = frmCrew.TxtCare
Sheet5.Cells(FilaRegistro, 20) = frmCrew.TxtMedical
Sheet5.Cells(FilaRegistro, 21) = frmCrew.TxtForklift
Sheet5.Cells(FilaRegistro, 22) = frmCrew.TxtArpa
Sheet5.Cells(FilaRegistro, 23) = frmCrew.TxtGmdss
Sheet5.Cells(FilaRegistro, 24) = frmCrew.TxtHSC
Sheet5.Cells(FilaRegistro, 25) = frmCrew.TxtAssist
Sheet5.Cells(FilaRegistro, 26) = frmCrew.TxtSecurity
Sheet5.Cells(FilaRegistro, 27) = frmCrew.TxtEcdis
Sheet5.Cells(FilaRegistro, 28) = frmCrew.TxtEcdis2
Sheet5.Cells(FilaRegistro, 29) = frmCrew.TxtCook
Sheet5.Cells(FilaRegistro, 30) = frmCrew.TxtFood
MsgBox "EDIT Crew OK", vbInformation, "BALEARIA"
Sheet5.Visible = False
Sheet5.Protect ("xxxx")
Sheet1.Select
End sub