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

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

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 wrote in message
...
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