Advertisement
veronikaaa86

07. Area Figures

Sep 13th, 2022
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. Sub LiveDemo()
  2. Dim result As Double
  3. result = ReturnArea("circle", 6)
  4. Debug.Print result
  5. End Sub
  6.  
  7.  
  8. Function ReturnArea(typeFigure As String, sideA As Double, Optional sideB As Double)
  9. Select Case typeFigure
  10. Case "square"
  11. ReturnArea = sideA * sideA
  12. Case "rectangle"
  13. ReturnArea = sideA * sideB
  14. Case "circle"
  15. ReturnArea = WorksheetFunction.Pi * sideA * sideA
  16. Case "triangle"
  17.  
  18. End Select
  19. End Function
  20.  
  21.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement