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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doube click cell to run macro 1
changing cell value by double clicking it with out vba/macros 1
Change cell font color when cell is clicked 9
Double Click Cell to Run Macro 2
Color changing VB Code 0
Color 8 cells on DBL click 2
conditional format - table - cell empty return default color 1
Making a cell a color using color numbers 7

Back
Top