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)
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.
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.
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...)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
