JL

There are three properties you could use, MemoryUsed, MemoryFree,
TotalMemory. Like so

Sub memory()
With Application
MsgBox "Total memory used: " & .MemoryUsed
MsgBox "Total memory free: " & .MemoryFree
MsgBox "Total memory: " & .MemoryTotal
End With
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"JL" wrote in message
...
Is it possible to monitor memory usage via vba? Basically,
when a certain percentage of memory is reached I would
like to show a message box asking the user to close some
applications.

Thank you