How to check your operating system using VBA

This VBA code will check your current operating systems and returns the operating system information. You can copy the code and paste it in Excel for Mac or Windows.

1. Copy the below VBA Code by clicking on the copy box
2. Open Microsoft Visual Basic for Applications window Developer Ribbon Tab > Visual Basic (Shortcut keys as follows for mac & windows)
   1. mac users fn + ⌥ [option] + F11
   2. windows users Alt + F11
3. From the menu bar select Insert > Module and insert new Modules
4. Paste the code into the module.

Note: It is always good to take a back-up copy of your original before running the code on the original file.

Sub CheckOS()
    'Made It Easy by ExcelExciting.com | Faraz Shaikh | Updated : 20200801
    Dim CheckOS As String
    '******************************************************
  	'Check the Operating system
    CheckOS = Application.OperatingSystem
    MsgBox "You are using " & CheckOS
    '******************************************************
End Sub

So the important part of code in the above code is “Application.OperatingSystem” checks the operating system and return the information.

Was the information helpful in this blog?

• If yes, hit that share button and show the excitement to the world.
• Subscribe to our free posts.

If no, please let us know what to improve.

Having trouble with any Office Apps. Feel free to ask and answer queries at our forums section.