M
Mark Kubicki
is there a way to show an information message when the cursor passes over a
specific cell?
specific cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pyball
Mark,
You can insert a comment into the Cell. No programming required
You can insert a comment into the Cell. No programming required
G
Gord Dibben
Mark
Insert>Comment might do?
Gord Dibben Excel MVP
Insert>Comment might do?
Gord Dibben Excel MVP
M
Mark Kubicki
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)
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)
B
bobgerman
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.
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.
O
onedaywhen
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.
--
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.
--
M
Mark Kubicki
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
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