Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have these two codes (below) in two seperate workbooks. Is it possible to
combine these two codes in one set of code in a single workbook, since someone told me that I cannot have two Workbook_Open events in one workbook. Just to tell you that I am a very beginner in programming. Code 1: In ThisWorkbook: ------------------- Private Sub Workbook_Open() StartBlink1 End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) StopBlink1 End Sub In Module: -------------- Public RunWhen As Double Sub StartBlink1() With ThisWorkbook.Worksheets("Champions League").Range("A2").Font If .ColorIndex = 3 Then ' Red Text .ColorIndex = 2 ' White Text Else .ColorIndex = 3 ' Red Text End If End With RunWhen = Now + TimeSerial(0, 0, 1) Application.OnTime RunWhen, "StartBlink1", , True End Sub Sub StopBlink1() ThisWorkbook.Worksheets("CHAMPIONS LEAGUE ").Range("A2").Font.ColorIndex = _ xlColorIndexAutomatic Application.OnTime RunWhen, "StartBlink1", , False End Sub Code 2. In ThisWorkbook: ------------------- Private Sub Workbook_BeforeClose(Cancel As Boolean) stopFlashing End Sub Private Sub Workbook_Open() startFlashing End Sub In Module: -------------- Option Explicit Dim nextSecond Sub startFlashing() flashCell End Sub Sub stopFlashing() On Error Resume Next Application.OnTime nextSecond, "flashCell", , False End Sub Sub flashCell() nextSecond = Now + TimeValue("00:00:01") Application.OnTime nextSecond, "flashCell" If Range("A114").Interior.ColorIndex = 3 Then Range("A114").Interior.ColorIndex = 5 Range("A114").Value = IIf(Range("K112") = Range("L112"), Range("A108"), IIf(Range("K112") Range("L112"), Range("E111"), Range("H111"))) ElseIf Range("A114").Interior.ColorIndex = 5 Then Range("A114").Interior.ColorIndex = 3 Range("A114").Value = "CHECKED" End If End Sub Any help is appriciated, thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
GL Codes | Excel Worksheet Functions | |||
2 codes in 1 | Excel Discussion (Misc queries) | |||
Help with codes | Excel Discussion (Misc queries) | |||
vba codes | Excel Programming | |||
re : Help Need on my codes | Excel Programming |