Floating Box

[Patricio Saul]

Hi,
I am working on a worksheet and I need to be constantly checking on the data on certain cells on another worksheet (always updated). I've been thinking on creating some kind of floating box to do so, I've tried with a Text Box but it is "stuck" to a certain part of the sheet and as I move, it dissapears...I've tried with a MsgBox but it won't let me move until I click the OK button.

This must be something really easy, but I'm such a rookie!
Thanx,

Patricio

[Leith Ross]

Hi,
I am working on a worksheet and I need to be constantly checking on the data on certain cells on another worksheet (always updated). I've been thinking on creating some kind of floating box to do so, I've tried with a Text Box but it is "stuck" to a certain part of the sheet and as I move, it dissapears...I've tried with a MsgBox but it won't let me move until I click the OK button.

This must be something really easy, but I'm such a rookie!
Thanx,

Patricio

Hello Patricio,

The easiest solution would be to split your Excel Screen in two. This way you can monitor the changing data while working on something else. Best of all, you don't have to write any code. If you don't know how to do this, consult your On-Line Excel Help.

Hope this helps,
Leith Ross

[Patricio Saul]

Thanks for that reply! I had already tried that but it's not so helpful...Can anyone help me with a code?
THANX AGAIN!

[Leith Ross]

Hello Patricio,

I will be glad to help you further with the code. Would you please post the code you are having the problems with. I am sure it can be resolved quickly and easily.

Thank You,
Leith Ross

[Patricio Saul]

Leith,
Can we start from scratch?
Thanx!

Patricio

[Leith Ross]

Hello Patricio,

If you can give me more details, examples, etc. I willbe glad to help you with creating the code. E-mail me or contact me here at the forum.

Best,
Leith Ross