I've written two functions to return the x and y coordinates for a userform which is to positioned relative to the active window. This works on Excel 2010 (Windows) and 2011 (Mac) but when I try it on 2016 with the ActiveWindow positioned halfway down the screen I get the value '2' returned for its .Top and .Left values!? Is this a recognised bug in 2016? Any workaround? Application.Top and .Left yields 0.

Thanks for reading.

Perhaps I should return to 2016 when Microsoft gets around to finishing it.