Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default Data Label Position | Charts and Charting in Excel | |||
Outside Label Position not listed | Charts and Charting in Excel | |||
Position of CellCursor on Screen (absolute position) | Excel Programming | |||
Bar charts with negative values and label position | Charts and Charting in Excel | |||
Data Label Object Position not working | Excel Programming |