Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
get reference to cell from mousedown event David Excel Programming 3 August 23rd 05 02:00 PM
Semi-transparent label background?? Jens Meier Excel Programming 1 July 25th 05 03:06 AM
Transparent Text Label Adrian[_7_] Excel Programming 1 August 3rd 04 08:03 PM
Transparent problem with frame. md.momo[_2_] Excel Programming 0 June 24th 04 06:26 PM
Transparent problem with frame. md.momo Excel Programming 0 June 23rd 04 05:49 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"