Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to chage existing workbooks background color jwsmith1967 Excel Discussion (Misc queries) 1 June 1st 10 07:51 PM
Making a cell a certain color for a value NDT_Steve Excel Worksheet Functions 3 January 22nd 09 11:25 AM
Making a Cell turn color based on results in another cell melaniem Excel Discussion (Misc queries) 6 January 11th 08 05:25 AM
I want to chage a whole rows text color based on single cell valu. thediamondfam Excel Worksheet Functions 2 January 12th 05 12:15 AM
Need help troubleshooting code which changes the color of a cell Larry Excel Programming 4 October 27th 04 06:29 PM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"