is there a way to show an information message when the cursor passes over a
specific cell?

Mark,

You can insert a comment into the Cell. No programming required

--
Message posted from http://www.ExcelForum.com

Mark

InsertComment might do?

Gord Dibben Excel MVP

On Thu, 18 Dec 2003 18:58:46 -0500, "Mark Kubicki"
wrote:

is there a way to show an information message when the cursor passes over a
specific cell?

exactly like a comment, except...
without that annoying little red triangle,
AND
i would want to program what the text of the message would be, (which would
vary -depending on other conditions)

----------------------------
is there a way to
<Gord Dibben wrote in message
...
Mark

InsertComment might do?

Gord Dibben Excel MVP

On Thu, 18 Dec 2003 18:58:46 -0500, "Mark Kubicki"

wrote:

is there a way to show an information message when the cursor passes over
a
specific cell?

This may not be the best way but I can get the "Hyperlink" function to
work for this.....give this a try.....

Select the cell you'd like to have the comment pop-up from, then right
click and choose "Hyperlink" from the drop-down. Click the
"ScreenTip..." button in the upper right corner of the Insert Hyperlink
dialog box and enter the message you want to pop-up.

Unless you want to actually set a hyperlink within this cell I would
suggest setting "Cell reference" to this same cell.

Also, this will re-format the cell for blue/underlined text. You can
change the formatting to what ever you like and it will still work.

This won't work for your "conditions" problem though.


---
Message posted from http://www.ExcelForum.com/

Well, you could use an invisible ActiveX control (e.g. an Image
control) from the Controls Toolbar placed over the cell and show a
label in its MouseMove event. But you'd need to detect when the mouse
moves away from the Image, so you'd need another invisible Image
control significantly larger than the original and hide the label in
its MouseMove event. Then you've got to handle things like the user
clicks the invisible controls, resizes/deletes the columns/rows etc.
All this is do-able but you wouldn't want to do it for more than a few
cells on a worksheet. And it's difficult to describe so if you're
interested, post back and I'll send you some demo code.

Or you could live with the little red triangle.

--

"Mark Kubicki" wrote in message ...
exactly like a comment, except...
without that annoying little red triangle,
AND
i would want to program what the text of the message would be, (which would
vary -depending on other conditions)

----------------------------
is there a way to
<Gord Dibben wrote in message
...
Mark

InsertComment might do?

Gord Dibben Excel MVP

On Thu, 18 Dec 2003 18:58:46 -0500, "Mark Kubicki"

wrote:

is there a way to show an information message when the cursor passes over
a
specific cell?

lol

thanks... it was for convenience, and not essential; for that much effort,
it's now for the "abandoned idea bin" !!

(and, you were precisely right about the user delete/resize issues; if you
know of a good (reading?) source for approaches to these types of issues,
I'd really like to know...)

again thanx

mark

----------------------------------------------------------------------------
------------------



"onedaywhen" wrote in message
m...
Well, you could use an invisible ActiveX control (e.g. an Image
control) from the Controls Toolbar placed over the cell and show a
label in its MouseMove event. But you'd need to detect when the mouse
moves away from the Image, so you'd need another invisible Image
control significantly larger than the original and hide the label in
its MouseMove event. Then you've got to handle things like the user
clicks the invisible controls, resizes/deletes the columns/rows etc.
All this is do-able but you wouldn't want to do it for more than a few
cells on a worksheet. And it's difficult to describe so if you're
interested, post back and I'll send you some demo code.

Or you could live with the little red triangle.

--

"Mark Kubicki" wrote in message
...
exactly like a comment, except...
without that annoying little red triangle,
AND
i would want to program what the text of the message would be, (which
would
vary -depending on other conditions)

----------------------------
is there a way to
<Gord Dibben wrote in message
...
Mark

InsertComment might do?

Gord Dibben Excel MVP

On Thu, 18 Dec 2003 18:58:46 -0500, "Mark Kubicki"

wrote:

is there a way to show an information message when the cursor passes
over
a
specific cell?