Playing MIDI-files using VBA in Microsoft Excel

Soundfiles in MIDI-format are often long, so it might be necessary to stop playing the sound (e.g. when the macro is finished). Here is an example: ...

Determine the type of operating system using VBA in Microsoft Excel

To identify the type of OS, we can use macro code. In this article we will learn how to determine the type of operating system being used using VBA co...

Restore the position in the window using VBA in Microsoft Excel

If you want to restore the screen picture for the user after a macro has changed the window view, you can sometimes just activate the cell that was t...

Determine the screen size using VBA in Microsoft Excel

With the macro below you can return the screen size with the function GetSystemMetrics32. Declare Function GetSystemMetrics32 Lib "User32" _ Ali...

How to Turn Off Warning Messages Using VBA in Microsoft Excel

Imagine you’ve written a VBA code that writes in a file, saves and closes it. Now, every time you run your code it shows a popup message in Excel li...

Display AutoFilter criteria after filtering using VBA in Microsoft Excel

In this article, we will create a macro to display the criteria used in auto filter. Raw data consists of client details, which includes Name, Phone ...

Grouping data using VBA in Microsoft Excel

  In this article, we will create a macro to group data on behalf of certain conditions. Raw data consists of Business Development team data. I...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube