Guest User

Untitled

a guest
Apr 23rd, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. If hiba = False Then
  2. Do
  3. If IsEmpty(Cells(sorszam, 1)) = False Then
  4. Else
  5. Cells(sorszam, 1) = txt_nev.Value
  6. Cells(sorszam, 2) = txt_email.Value
  7. Cells(sorszam, 3) = combox_szolgaltato.Value
  8. Cells(sorszam, 4) = txt_tel.Value
  9. If opt_gkar = True Then
  10. Cells(sorszam, 5) = "G"
  11. Else
  12. If opt_kkar = True Then
  13. Cells(sorszam, 5) = "K"
  14. Else
  15. Cells(sorszam, 5) = "T"
  16. End If
  17. End If
  18. Cells(sorszam, 6) = eletkor
  19. Cells(sorszam, 7) = txt_matek.Value
  20. Cells(sorszam, 8) = txt_info.Value
  21. Cells(sorszam, 9) = Left(listbox_velemeny, 1)
  22. End If
  23. sorszam = sorszam + 1
  24. Cells(1, 12) = sorszam
  25. Loop Until IsEmpty(Cells(sorszam, 1)) = True
  26. Cells(sorszam, 1) = rofllolz
Add Comment
Please, Sign In to add comment