To use the MemoryStatus class, first declare a new instance of the class, and then retrieve any of its properties. For example, the most interesting property of the MemoryStatus class is the MemoryLoad property, which tells you the approximate current memory utilization. To retrieve the value of this property, you write code like this:
Dim oms As New MemoryStatus
Debug.Print "The total physical memory is: " & oms.TotalPhysical
Use the same technique with any, or all, of the MemoryStatus class properties.