Thread: show message
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mark Kubicki Mark Kubicki is offline
external usenet poster
 
Posts: 89
Default 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?