Advertisement
Guest User

Untitled

a guest
Jul 24th, 2014
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. Sub dural()
  2. MsgBox Application.Version
  3. End Sub
  4.  
  5. Sub Excel_Version()
  6.  
  7. Select Case (Val(Application.Version))
  8.  
  9. Case 8
  10. MsgBox "You use Excel 97"
  11. Case 9
  12. MsgBox "You use Excel 2000"
  13. Case 10
  14. MsgBox "You use Excel 2002"
  15. Case 11
  16. MsgBox "You use Excel 2003"
  17. Case 12
  18. MsgBox "You use Excel 2007"
  19. Case 14
  20. MsgBox "You use Excel 2010"
  21. Case 15
  22. MsgBox "You use Excel 2013"
  23. End Select
  24.  
  25. MsgBox "Welcome to Microsoft Excel version " & _
  26. Application.Version & " running on " & _
  27. Application.OperatingSystem & "!"
  28.  
  29. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement