Private Sub CommandButton1_Clickti If nif.Value ** Then rangelaidao90), Kndtzlur Offsetil hất nhà Else MsgBox "La casill
Posted: Tue Jul 12, 2022 8:11 am
- 1 (52.65 KiB) Viewed 25 times
- 2 (83.2 KiB) Viewed 25 times
- 3 (46.95 KiB) Viewed 25 times
- 4 (46.95 KiB) Viewed 25 times
Private Sub CommandButtoni clickt) Range("a1000000") End (x10p) offset (1.0).Select Activecell.value- nif.Value ActiveCell.offset(0, 1) nombre.Value ActiveCell.offset (0, 2) apellido Valme Activecell.offset(0, 31 carnet Value Bise Magbox "La casilla nit es requerida" hit.Bet Focus End It End Sub I Private Sub Userform Initialize() End Sub
7 50187458w Luis 58449849r 65465461 59898798u 9 D NIF 98798798y Maria 5465465t 55646546 Antonio 546540 David 0566546y Sonia 6544564p Sara 2 6546546u Olga 3 6546546d Isabel 44654654k Luis 5 6546546y gerardo 6 1 2 9: A 5 5 B Nombre C Apellido Martin D Carnet si no Fernandez si sl si Diaz Lopez Esteban no no Tipo E tipo c tipo c no tiene no tiene F Genera femenino masculino masculino G H Abrir Formulario 1 5.P