Code for making a cell chage color by dbl clicking, with either a

I am trying to find out how to write the code for making a stylis on a tablet
PC, change the color of a cell by dbl clicking on it. For when it does that
it also trigers one sequence or another.

If anyone can hlep or point me in the direction I need to take to get this
going I would be greatfull.

Thanks

Have you looked at the beforedoubleclick event. It has a cancel argument
which if you set it to true will cancel the normal functionality of the
doubleclick. Your code then acts as the functionality.

See Chip Pearson's overview of event programming
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Zan Dorris" <Zan [email protected]> wrote in message
news:[email protected]...
> I am trying to find out how to write the code for making a stylis on a
tablet
> PC, change the color of a cell by dbl clicking on it. For when it does
that
> it also trigers one sequence or another.
>
> If anyone can hlep or point me in the direction I need to take to get this
> going I would be greatfull.
>
> Thanks

Have you looked at the beforedoubleclick event. It has a cancel argument
which if you set it to true will cancel the normal functionality of the
doubleclick. Your code then acts as the functionality.

See Chip Pearson's overview of event programming
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Zan Dorris" <Zan [email protected]> wrote in message
news:[email protected]...
> I am trying to find out how to write the code for making a stylis on a
tablet
> PC, change the color of a cell by dbl clicking on it. For when it does
that
> it also trigers one sequence or another.
>
> If anyone can hlep or point me in the direction I need to take to get this
> going I would be greatfull.
>
> Thanks