Re: Blinking Cell (Worksheet restarts)

hmm....all i can think of is recording the whole formatting program and
running the macro each time a new work sheet is added.

i'm sure there's some vba code that states 'IF new worksheet added, run
macro "xxx"'

try using the help assistant i guess...

sorry i couldnt help much.

fd


--
FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup access

Hi guys,

I couldn't find the begining of this thread in Google, but have you
considered the following solution. It has the advantage of preserving the
undo functionality of Excel and the disadvantage of a constantly running
code.

Regards,
KL

1) Create a named formula called TIMER
=MOD(SECOND(NOW()),2)=1

2) Select the range you want to blink subject to a condition (or multiple
conditions), say range A1:A100

3) Apply the following Conditional Format
=TIMER*(A1<0)

where (A1<0) is one of the many possible conditions.

4) put the following code into the VBA module of ThisWorkbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

Private Sub Workbook_Open()
StartBlinking
End Sub

5) put the following code into a standard module (say Module1):

Dim dtNext As Date

Sub StartBlinking()
dtNext = Now + TimeValue("00:00:01")
Application.Calculate
Application.OnTime dtNext, "StartBlinking"
End Sub

Sub StopBlinking()
Application.OnTime dtNext, "StartBlinking", schedule:=False
End Sub

kudos KL,

but does that mean that my workbook would still restart when i quit
it?


thanks,
fd


--
FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup access

I'd be surprised if it did :-)

KL



"FloggingDolphin" <FloggingDolphin.1s5zqc@> wrote in message
news:[email protected]...
>
> kudos KL,
>
> but does that mean that my workbook would still restart when i quit
> it?
>
>
> thanks,
> fd
>
>
> --
> FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup access
>

hey there, thanks for that advice. Can you just teach me how to name a
formula called TIMER. Is that a Macro or something? I tried to check
excel help on how to create and name formulae but failed.

thanks
fd


--
FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup access

Hi FloggingDolphin,

This is [almost] exactly the same as a named range. Essentially when you
create a named range you create a named formula as you enter something like
=A1 which is a formula refering to a range. So the step-by-step is:

1) on the spreadsheet window go to menu Insert>Name>Define
2) enter "Timer" (w/o quatation marks) into the 'Names in workbook' box
3) enter =MOD(SECOND(NOW()),2)=1 into the 'Refers to:' box
4) press Add, OK

Voila!

Regards,
KL


Regards,
Kl


"FloggingDolphin" <FloggingDolphin.1sdtcm@> wrote in message
news:[email protected]...
>
> hey there, thanks for that advice. Can you just teach me how to name a
> formula called TIMER. Is that a Macro or something? I tried to check
> excel help on how to create and name formulae but failed.
>
> thanks
> fd
>
>
> --
> FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup access
>

I’ve tried it out and it works. Thanks!

One other thing. I’d like it to Stopblink after I input a value
between 1 and 13 in the cell (C1). This is in order to prevent it to
constantly re-calculating and making my whole spreadsheet slightly
blink.

I’d also like to Start blink should my cell (C1) become clear
again.

If it's alright, can you please tell me what VBA code to add to do the
above?

Thanks again,

FD


--
FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup access