View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Passing a control to a Sub


a = me.label1 'will pas the text for the label
set a = me.label1 'will pass the label object

"Art" wrote:

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?