Advertisement
Guest User

Untitled

a guest
Nov 12th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. Function SUMA_OD_DO(Lp As Single, Lk As Single) As Single
  2. Dim suma As Integer
  3. For i = Lp To Lk
  4. suma = suma + i
  5. Next i
  6. SUMA_OD_DO = suma
  7. End Function
  8.  
  9. Sub ILEE()
  10. Dim x As Integer
  11. Dim wartość As Integer
  12. x = InputBox("Wprowadz liczbe ILE")
  13. For i = 1 To x
  14. Sheets("Arkusz2").Cells(1, i) = i
  15. Next i
  16. End Sub
  17.  
  18. Sub zad3()
  19. Dim x As Integer
  20. Dim wartość As Single
  21. x = InputBox("Wprowadz numer kolumny")
  22. For i = 1 To 10
  23. wartość = Cells(i, 1)
  24. Cells(i, x) = Abs(wartość)
  25. Next i
  26. End Sub
  27.  
  28. Sub zad4()
  29. Dim i As Integer
  30. Dim wartość As Integer
  31. Dim ujemne
  32. For i = 1 To 10
  33. wartość = Cells(i, 1)
  34. If wartość < 0 Then
  35. wartość = Abs(wartość)
  36. ujemne = ujemne + 1
  37. ElseIf wartość > 0 Then
  38. wartość = wartość
  39. If ujemne > 0 Then
  40. MsgBox ("Liczba dokonanych zamian " & ujemne)
  41. Else
  42. MsgBox ("Brak wartości ujemnych")
  43. End If
  44.  
  45. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement