Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Data Label Position Kermit Charts and Charting in Excel 2 January 16th 08 01:18 AM
Outside Label Position not listed Debbie Charts and Charting in Excel 1 September 8th 06 10:28 AM
Position of CellCursor on Screen (absolute position) [email protected] Excel Programming 1 November 23rd 05 02:23 AM
Bar charts with negative values and label position Pearl Quan Charts and Charting in Excel 3 April 25th 05 10:51 PM
Data Label Object Position not working Sean[_7_] Excel Programming 0 August 12th 04 10:14 PM


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"