Using ActiveWindow.PointsToScreenPixelsY

  • Thread starter Thread starter Pancho
  • Start date Start date
P

Pancho

I am trying to use the ActiveWindow.PointsToScreenPixelsY
and all I have is a zero, as response.
I tryed:
hMap=ActiveWindow.PointsToScreenPixelsY(1)
hMap=ActiveWindow.PointsToScreenPixelsY(10)
hMap=ActiveWindow.PointsToScreenPixelsY(100)
hMap=ActiveWindow.PointsToScreenPixelsY(1000)

hMap is a Long variable, in all cases I obtained a zero.
I am using it on Excel 2000, with Windows 2000.

Any suggestions?
 
I get the same result when running from VB.
But if I create a macro and run that macro from an Excel button, then it
works.

Doesn't seem to like runnig from VB
 
Is that because the activewindow is the VBE?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks BOB that was the reason , I was seeing in Debug
mode.
Sorry for the lapsus,
Thanks
 
The real problem, seems to be related with the instruction
Application.screenUpdating=False


Thanks
 
I thought it might have been, so I msgboxed ActiveWindow.Caption and it came
back as Book1.

In fact: MsgBox Windows("Book1").PointsToScreenPixelsY(1000) comes back as
0. Yet if I hit ALT+F8 from Excel and run my macro then it gives a result.

Maybe it's a bug.
 
Back
Top