Use the GetActiveWindow API.

Code:
Declare Function GetActiveWindow Lib "user32" Alias "GetActiveWindow" () As Long