Positioning a Text Box

[Brad E.]

Hi to all,

If a cell changes to a certain value, I need to warn the user about another
action. I am using a simple Text Box which I have chosen to display for 3
seconds. The only thing I need help with is how to display this pop-up Text
Box in different positions.

The cell being looked at by Worksheet_Change event is in row 81. Depending
on how much the user scrolls before changing the value, row 81 may be near
the top, middle or bottom of the screen. I have noticed if row 81 is near
the top of the screen, I don't see the Text Box pop up near the bottom of the
screen. Is there a way to determine the vertical position of the active cell
(row 81)? Of course, in the spreadsheet itself, the vertical position of row
81 will always be the same. I really need to know the vertical position on
the user's monitor. Maybe I need to know the top row which is visible to the
user at the time row 81 is changed??

Thanks for your time.

 

[Brad E.]

Well, I kept playing with it, and it just so happens that the other action I
am taking is "Unchecking" a Check Box. So, to position my Text Box, I just
referenced the .Top attribute of the Check Box I am modifying.

That got me to thinking, though, and using Target.Top works just the same.
Of course, Target is the cell which is changing in the Worksheet_Change event.

Conclusion - The position of a Text Box is relative to the spreadsheet and
not the monitor. I think this is where I was originally confused.