B
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.
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.