![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
Hi.
Writing a procedure to cause a cell to blink if certain conditions are not met... However, a double-click in any cell causes the procedure to stop??? See: http://www.mrexcel.com/board/viewtop...6567&forum=2&5 Code Here:
Thanks, Tom |
|
|
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Auckland, New Zealand
Posts: 4,209
|
Hi Tom ??
Not too sure but apparently if you are in some sought of edit mode eg doubleclick or formula edit / cell edit THEN IF the Timer passes the Start value the function call is RESET....not sure why ?? Will have a look further (time pemitting) Just a side note: Sometimes you discover different things when you least expect it. Perhaps this could be used to your advantage on something else ?? Just as an example Xl97 / Userform:- I found that exercuting a call to displaying the Help About ms excel caused the Userform to become Non Modal !! so I didn't have to do any API calls ......No one could explain it. I even asked John Walkenback.... I'll keep this in mind...may come in handy. |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
Thanks for the reply Ivan
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|