Flashing Date in excel

[Ienni1983]

Hello All,

this is my very first post and also first question since I am breaking my brains over this one since I have been working with Excel 2007.

I have solved many problems with the solutions presented here.

I have multiple workbooks which contains numerous different dates.

and I need to make them flash when the dates are due within one week etc.

I would like to know what kind of command in vba or formula in excel it needs.

Kind Regards,
Vincent Arjan van Vessem

 

[TheNoocH]

welcome to the board...not sure if you can make them flash...BUT...what I would do would be set up conditional formatting to highlight the cell based upon the date being within a week...

 

[Ienni1983]

Well I have noticed that the cells can flash when you make a vba formula for it but The exact commands for that combination is a bit unknown to me.

I am reading up a book on Excel 2007 VBA for dummies but it is not included for all I know atm

 

[TheNoocH]

see if this link does the trick...

http://excel.tips.net/Pages/T002134_Flashing_Cells.html

 

[Ienni1983]

it appears that only applies from 2000 to 2003 and not 2007

 

[Weaver]

Where did it go wrong? Were there any error messages?

 

[picklefactory]

I use this in one workbook, hope it makes sense

Dim NextTime As Date

Sub Flashing()
 NextTime = Now + TimeValue("00:00:02")
 With ActiveWorkbook.Styles("Flashing").Font
   If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2
 End With
 Application.OnTime NextTime, "Flashing"
End Sub

Sub StopIt()
 On Error GoTo Skip
 Application.OnTime NextTime, "Flashing", schedule:=False
 ActiveWorkbook.Styles("Flashing").Font.Color = -16776961
 MsgBox "I know it's irritating, but it's important you didn't miss that.", , "Sorry......"
Skip:
 End Sub

Sub StopIt2()
 On Error GoTo Skip
 Application.OnTime NextTime, "Flashing", schedule:=False
 ActiveWorkbook.Styles("Flashing").Font.Color = -16776961
Skip:
 End Sub

 

[picklefactory]

TheNoocH

Apologies, I need my glasses, didn't see your link.
Same thing, pretty well.

 

[Ienni1983]

well I got it to work but gotta work out the kinks now ^^

 

[Ienni1983]

allright I have got it working to flash but now I need it to start flashing if the specific date is within now and one week.

but the current one is for hours minutes and seconds.

god Visual Basic is one tough cookie