Advertisement
maciejms

VBA 5

May 29th, 2019
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Option Explicit
  2. Function silnia_(n As Integer) As Long
  3. Dim i As Integer
  4.     silnia_ = 1
  5.     For i = 1 To n
  6.         silnia_ = silnia_ * i
  7.     Next i
  8. End Function
  9. Function inicjaly(fName As String, sName As String) As String
  10.     inicjaly = Left(fName, 1) & ". " & Left(sName, 1) & "."
  11. End Function
  12. Function email(fName As String, sName As String) As String
  13.     Dim i As Integer, a As Integer, len1 As Integer, len2 As Integer
  14.     len1 = Len(fName)
  15.     len2 = Len(sName)
  16.     For i = 1 To len1
  17.         a = Asc(Right(Left(fName, i), 1))
  18.         If a < 90 Then
  19.             a = a + 32
  20.         End If
  21.         email = email & Chr(a)
  22.     Next i
  23.     email = email & "."
  24.     For i = 1 To len2
  25.         a = Asc(Right(Left(sName, i), 1))
  26.         If a < 90 Then
  27.             a = a + 32
  28.         End If
  29.         email = email & Chr(a)
  30.     Next i
  31.     email = email & "@zarz.agh.edu.pl"
  32. End Function
  33. Function nwd(a As Integer, b As Integer) As Single
  34. Dim r As Integer
  35.     Do
  36.         r = a Mod b
  37.         If r = 0 Then
  38.             nwd = b
  39.         Else
  40.             a = b
  41.             b = r
  42.         End If
  43.     Loop Until r = 0
  44. End Function
  45. Function newton(n As Integer, k As Integer) As Double
  46.     newton = silnia_(n) / (silnia_(k) * silnia_(n - k))
  47. End Function
  48. Function ToBin(dec As Integer) As String
  49.     Dim bin As Integer, res As String
  50.     Do Until dec = 0
  51.         bin = dec Mod 2
  52.         dec = dec \ 2
  53.         res = res & bin
  54.     Loop
  55.     ToBin = StrReverse(res)
  56. End Function
  57. Function sReverse(tekst As String) As String
  58.     sReverse = StrReverse(tekst)
  59. End Function
  60. Function PoleTrojkata(ByVal a As Integer, ByVal b As Integer, ByVal c As Integer) As Double
  61. ' wzor Herona
  62.    Dim p As Double
  63.     If (a + b > c) And (a + c > b) And (c + b > a) Then
  64.         p = (a + b + c) / 2
  65.         PoleTrojkata = Sqr(p * (p - a) * (p - b) * (p - c))
  66.     Else
  67.         PoleTrojkata = 0
  68.     End If
  69. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement