show message
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?
|