Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks this is very helpful - glad you were able to dig it up from
your archive. On Aug 8, 11:28 pm, Greg Wilson wrote: Sorry, the CorrectZoomFactor function was half-baked and you need to make another minor change. In the MoveShapeToMouse macro, change: z = CorrectZoomFactor(.Zoom) to: z = CorrectZoomFactor(.Zoom / 100) Also, substitute the following for the CorrectZoomFactor function: Function CorrectZoomFactor(ByVal z As Single) As Single Select Case z Case 2 z = 2 Case 1.75 z = 1.765 Case 1.5 z = 1.529 Case 1.25 z = 1.235 Case 1 z = 1 Case 0.9 z = 0.882 Case 0.85 z = 0.825 Case 0.8 z = 0.82 Case 0.75 z = 0.74 Case 0.7 z = 0.705 Case 0.65 z = 0.645 Case 0.6 z = 0.588 Case 0.55 z = 0.53 Case 0.5 z = 0.5296 Case Else z = 1.0069 * z + 0.0055 End Select CorrectZoomFactor = z End Function Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
GREG I need your expertise again | Excel Discussion (Misc queries) | |||
Using Air Coordinates in a Worksheet | Excel Worksheet Functions | |||
Simple way to convert UTM ED50 coordinates to decimal coordinates? | Excel Programming | |||
Converting MouseDown Coordinates to Chart Point Coordinates | Excel Programming | |||
A MAJOR LEAGUE THANKS TO JOHN WILSON | Excel Programming |