![]() |
label position affected by wide screen?
Investigating a problem where users of new wide screen PCs have found errors
in selection of labels on form (written by ex-employee). They attempt to select a value on screen, but reply to different value is returned. VBA Label properties in form define screen position - left & top both specified and height & width. Is it possible that wide screen resolution is not being resolved to correct position by Excel/VBA? -- Patricia D |
label position affected by wide screen?
I switched to wide screen recently and after following the instructions to
reset the screen resolution, I have had no problems with results from any previouly designed forms. I did however have to do some re-positioning of shapes that were set to specific pixel values since the screen width increased considerably in pixel measurement. But any that were set to half the screen width or one fourth the screen width, etc. should not have a problem since vb will calculate it for the user. "Patricia D" wrote: Investigating a problem where users of new wide screen PCs have found errors in selection of labels on form (written by ex-employee). They attempt to select a value on screen, but reply to different value is returned. VBA Label properties in form define screen position - left & top both specified and height & width. Is it possible that wide screen resolution is not being resolved to correct position by Excel/VBA? -- Patricia D |
label position affected by wide screen?
You might have pointed me in the right direction... The background frame and
image have picture alignment of TopLeft and picture size mode of ModeClip - does this mean it will not resize according to screen resolution, but retain the size of form, as cerated on designer's screen resolution? Each of the labels sitting on the frame has a left, top position in pixels, which I assume would be calculated according to screen resolution. I think I will need to obtain a wide screen PC to follow the action by stepping through the click process on a form. -- Patricia D "JLGWhiz" wrote: I switched to wide screen recently and after following the instructions to reset the screen resolution, I have had no problems with results from any previouly designed forms. I did however have to do some re-positioning of shapes that were set to specific pixel values since the screen width increased considerably in pixel measurement. But any that were set to half the screen width or one fourth the screen width, etc. should not have a problem since vb will calculate it for the user. "Patricia D" wrote: Investigating a problem where users of new wide screen PCs have found errors in selection of labels on form (written by ex-employee). They attempt to select a value on screen, but reply to different value is returned. VBA Label properties in form define screen position - left & top both specified and height & width. Is it possible that wide screen resolution is not being resolved to correct position by Excel/VBA? -- Patricia D |
All times are GMT +1. The time now is 04:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com