Form Position using .top and .left

[solnajeff]

Hi

I have a worksheet that saves the values of .top and .left so that users may position a form to suit their preferences. However I noticed that there is a small difference between the value recorded and the value read (see attached). Originally I thought that it was related to the border of the form, but then found that the values were different for normal and fullscreen views in Excel 2000, but not in 2010. As I do not currently have any other versions to check I wonder if anyone has come across this before in other versions of Excel and if there are any other variations.

Regards

Jeff

[Jack in the UK]

have a play with this (sit top left - zero point)

Please Login or Register  to view this content.

[royUK]

I think the best way to position a form is to use Chip Pearson's code

[snb]

You can use Word's VBA to retrieve the screenresolution.
Depending on the screenresolution you can adapt the userform's top and left-properties.

Please Login or Register  to view this content.

[solnajeff]

Hi Guys

Thanks for the advice.

I think the best option at present is to use variables to allow for the difference and Application.version to test for Excel 2000 and change the relevant values.

Thanks again

Regards

Jeff