ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   On MouseOver for Cells/Sheets (https://www.excelbanter.com/excel-programming/340652-mouseover-cells-sheets.html)

Andrew

On MouseOver for Cells/Sheets
 
Is there an on mouseover event for a cell..? or sheet..? or anything..?

Want to create a floating message type box, to give the user of a sheet some
help when they
move the mouse over an item, or value or other data type.

any help/hints would be appreciated.
Andrew





Chip Pearson

On MouseOver for Cells/Sheets
 
There is no MouseOver or MouseIn event for a cell. For your
purposes, would a cell comment do the job?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Andrew" <NoToSPAM@home wrote in message
...
Is there an on mouseover event for a cell..? or sheet..? or
anything..?

Want to create a floating message type box, to give the user of
a sheet some
help when they
move the mouse over an item, or value or other data type.

any help/hints would be appreciated.
Andrew







Jake Marx[_3_]

On MouseOver for Cells/Sheets
 
Hi Andrew,

Andrew wrote:
Is there an on mouseover event for a cell..? or sheet..? or
anything..?


There aren't any exposed mouse-related events for cells or sheets.

Want to create a floating message type box, to give the user of a
sheet some help when they
move the mouse over an item, or value or other data type.


You could use comments (Insert | Comment) if you need cell-based tooltips.
If you're after something more extravagant, you could use TextBoxes or other
ActiveX controls, which do expose mouse events.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]



Andrew

On MouseOver for Cells/Sheets
 

"Chip Pearson" wrote in message
...
| There is no MouseOver or MouseIn event for a cell. For your
| purposes, would a cell comment do the job?

Not really, might just do it in a web page instead.

If there is no way to Expose/make accessible the mouse over events (same as
comments use) then will try a few other tings.
Thx for reply.
A


| --
| Cordially,
| Chip Pearson
| Microsoft MVP - Excel
| Pearson Software Consulting, LLC
| www.cpearson.com
|
|
| "Andrew" <NoToSPAM@home wrote in message
| ...
| Is there an on mouseover event for a cell..? or sheet..? or
| anything..?
|
| Want to create a floating message type box, to give the user of
| a sheet some
| help when they
| move the mouse over an item, or value or other data type.
|
| any help/hints would be appreciated.
| Andrew
|
|
|
|
|
|




All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com