AW: Bei MouseOver über Link Bild zeigen
02.06.2008 10:20:00
Tobias
für die Maus geibt es nur die Aktionen Doppelklick und rechte Maustaste.
...und zusätzliche Events mit dem xlEventServer von http://www.rtsoftwaredevelopment.de/
Trivial ist die Lösung nicht, aber möglich.
Einen ähnlichen Post findest Du auch unter: http://www.eggheadcafe.com/software/aspnet/28769207/-custom-mouse-over-cel.aspx
Custom Mouse over Cell Event Help - Thomas Risi
11-Dec-06 12:10:03
JLGWhiz schrieb:
On my website, you'll find a com-addin named xlEventServer (description
is only in german; tested with german-excel, WinXP Home/Pro and
Win2000). It triggers some new events, like OnMove, OnButtonDown,
OnMouseWheel. But use on your own risk :-)
Install the addin, and add the following code to a normal code-module.
Option Explicit
Private BlockOnMove As Boolean
Public EnableWheelEvent As Boolean
Private Const DELTA_MOUSEWHEEL = 3&
Private Const DELTA_ZOOM = 5&
' Enables OnMouseWheel-Event ...
Public Function GetWheelState() As Boolean
'GetWheelState = EnableWheelEvent
GetWheelState = False
End Function
' OnMove-Event
Public Sub OnMove(Target As Excel.Range, x As Long, y As Long)
On Error Resume Next
If Not BlockOnMove And Selection.Count = 1 Then
Static oldRange As Excel.Range
oldRange.Interior.ColorIndex = oldRange.Interior.ColorIndex Xor 4
If Target.Interior.ColorIndex
">http://rtsoftwaredevelopment.de