Flashing Date in excel

Ienni1983

New Member
Joined
May 29, 2009
Messages
6
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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...
 
Upvote 0
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
 
Upvote 0
I use this in one workbook, hope it makes sense
Code:
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
 
Upvote 0
TheNoocH

Apologies, I need my glasses, didn't see your link.
Same thing, pretty well.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,224,226
Messages
6,177,274
Members
452,765
Latest member
Erka Gizli

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top