Positioning of textbox

[MarcoAUA]

Hi you'll

please see: http://www.excelforum.com/excel-prog...s-visible.html
for the beginning of the solving from my problem.
In short: I like Textboxes to stay visible where ever you scroll to. I have found the code to do that:

Please Login or Register  to view this content.

.

My question is: what does the # 151 (in this case) means? It is not the pixels. But what then?
I would make my life a lot easier if i know what this number means so I can position my Textboxes where I want them to be, and stay where they are when scrolling through the sheet.

Any answer is welcome.

marcoAUA.

[john55]

hi,
it's a distance. take it out and you see the textbox's position.

[AlvaroSiza]

= .Top is the top of the application.
= .Left is the left most of the application.

(In a blank, newly opened worksheet, = .Top, = .Left would generally represent the position of Cell A1)

So = .Top and = .Left+151 represent the position of your text box as the upper left most portion of the visible worksheet, incremented by a value of 151 to the right.

I have not seen any documentation as to the exact definition of
a) what the numbers represent (you will see them called 'values' or indexes'; or
b) how many there are on a given screen under a given resolution so as to properly manipulate in a known (or unknown) environment.

-as-

[OnErrorGoto0]

It is in points rather than pixels.

[MarcoAUA]

How much distance is then 1 point?

In column width is given in 2 numbers: i.e. 8.43 (64 pixels) in a newly opened wb.
Is it known how these points relate to the column width or height?

It would make it a lot easier to position textboxes when you know this relation.

THNX