ActiveWindow.PointsToScreenPixelsY

[Legacy 456155]

Any idea why the following would return a negative number?

Debug.Print ActiveWindow.PointsToScreenPixelsX(0)

This line of code was returning what I expected and then all of the sudden began returning a negative number. A negative number on a two monitor desktop and my laptop as well. I searched and could find next to nothing.

ActiveWindow.PointsToScreenPixelsY seems to be working.

Thanks!

 

[Rick Rothstein]

I am guessing .. monitor 1 is on the right and has the taskbar on it whereas monitor 2 is on the left. Zero horizontally is at the left side of monitor 1 so points to the left of it would be negative.

 

[Legacy 456155]

Thanks Rick. It's also returning a negative number on my laptop with no external monitors connected.

 

[Legacy 456155]

Well, I copied the project to a new workbook and it now works as intended. Problem solved? Not really.