LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Art Art is offline
external usenet poster
 
Posts: 587
Default Passing a control to a Sub


Hi,

I've got a form with some labels on it. On the click event of one of the
labels, I'd like to pass the label to another sub in the code for that form.
It seems to pass the caption for the label.

I tried, within the click event, to assign the label (me.label1) to a
variable that I declared as a label. This also failed.

Is there a way to make this work?


 
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
Passing a Control as an Argument Goofy Excel Programming 14 November 1st 06 11:38 AM
Passing a Forms Control to Function Pflugs Excel Programming 5 August 24th 06 10:34 PM
passing range from RefEdit control Greg Excel Programming 1 April 25th 06 04:51 AM
Passing Control when workbooks have the same name shawb[_3_] Excel Programming 5 September 28th 05 01:59 PM
Passing the Name of a Control Between Macros Sandy Excel Programming 2 May 4th 05 03:02 PM


All times are GMT +1. The time now is 09:15 AM.

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"