Advertisement
Guest User

vba

a guest
Jul 5th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub Modul()
  2.     Const countElement As Integer = 12
  3.    
  4.     MsgBox ((1 + 2) / 2)
  5.    
  6.     Dim Massiv(countElement) As Integer
  7.  
  8.     For i = 0 To countElement
  9.         Massiv(i) = InputBox("Значение " & i & " элемента")
  10.         Next i
  11.    
  12.     Dim sum As Double
  13.    
  14.     sum = 0
  15.  
  16.     For i = 0 To countElment
  17.         sum = sum + Massiv(i)
  18.         Next i
  19.        
  20.     sum = sum / countElement
  21.     MsgBox (sum)
  22.        
  23.     Dim C As Integer
  24.     C = InputBox("Введите С")
  25.    
  26.     If sum Mod C = 0 Then
  27.         Dim maxElement As Integer
  28.        
  29.         maxElement = Massiv(0)
  30.        
  31.         For i = 1 To countElement
  32.             If maxElement < Massiv(i) Then maxElement = Massiv(i)
  33.            
  34.         Next i
  35.        
  36.         For i = 0 To countElement
  37.             If Massiv(i) - C Mod (i + 1) Then Massiv(i) = maxElement
  38.         Next i
  39.     Else
  40.         Dim min, max As Integer
  41.        
  42.         min = max = Massiv(0)
  43.        
  44.         For i = 0 To countElement
  45.             If min > Massiv(i) Then min = Massiv(i)
  46.             If max < Massiv(i) Then max = Massiv(i)
  47.         Next i
  48.        
  49.         Dim polusum As Integer
  50.         polusum = (min + max) / 2
  51.        
  52.         For i = 0 To countElement
  53.             If i Mod 2 = 1 Then Massiv(i) = polusum
  54.         End
  55.     End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement