Ben,

It seems to me that you have a problem here.

Using the class code method to simulate control arrays, the event code gets
triggered on a control click. If you call it directly, the control is not
implicitly declared to the event. So, you need to make it known somehow,
such as a public variable, but this would negate some of the advantages (but
not all) of the control array method.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ben" wrote in message
...
Thank you,

Unfortunately my question was still not explicit enough, it is a bit more
complicated than that as I am using a special work around to have several
hundred controls call the same code, and so the code has a recognizable
object on clicking, however just calling the code will not return an
object,
but anyway I found another way to accomlplish what was needed. Thank you
though

"Sharad Naik" wrote:

Sorry I completely misunderstood your question.

When you want to fire the evenet for clicking on Label1 in Sheet1, you
can
simply do

Run "Sheet1.Label1_Click"

You can use it even in a module.

Sharad

"ben" wrote in message
...
simple question

Is there a way to simulate the clicking of a control through vba?

eg..
Sheet1 contains a label named 'l12' and will change colors when
clicked,
is there a way to cimulate actually clicking it so that the code for
its
event is triggered?