Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mousedown event on transparent label problem
Hi guys, i am a beginner to all of this.
I have a transparent label over some cells with data. I need the mousedown event of the label to capture the data underneath and copy it to another cell. The data underneath the label is always changing and the problem is it becomes obscured when i mousedown on it by the backcolor of the label ( even though it is set to transparent). i found something on a another post: label1.parent.select this line does stop the backcolor of the label appearing but does not solve my problem because the _click event does not execute when i lift the mouse. so what i need is the mousedown to copy data somewhere. If the copied data meets my needs i will release the mouse button over label1 and the click event is executed. If the copied data is not suitable then i drag my mouse away from the label and the click event is not executed. At the moment i can do this no problem - but not without obscuring the data that is always changing under label1! thankyou very much for any help offered. I hope i explained things clearly enough. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
get reference to cell from mousedown event | Excel Programming | |||
Semi-transparent label background?? | Excel Programming | |||
Transparent Text Label | Excel Programming | |||
Transparent problem with frame. | Excel Programming | |||
Transparent problem with frame. | Excel Programming |