background flashes Free Excel Macros (VBA) | Excel Programs

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php

Sub FlashBack() 
'Make cell range Background color, flash x times, x fast, in x color, 
'when Ctrl-a is pressed.

Dim newColor As Integer 
Dim myCell As Range 
Dim x As Integer 
Dim fSpeed

'Make this cell range background flash! 
Set myCell = Range("A1:M8") 
Application.DisplayStatusBar = True 
Application.StatusBar = "... Select Cell to Stop and Edit or Wait for Flashing to Stop! "

'Make cell background flash to this color! 
'Black 25, Magenta 26, Yellow 27, Cyan 28, Violet 29, Dark Red 30, 
'Teal 31, Blue 32, White 2, Red 3, Light Blue 41, Dark Blue 11, 
'Gray-50% 16, Gray-25% 15, Bright Cyan 8. 
newColor = 11

'Make the cell range flash fast: 0.01 to slow: 0.99 
fSpeed = 0.2

'Make cell flash, this many times! 
Do Until x = 2

'Run loop! 
DoEvents 
Start = Timer 
Delay = Start + fSpeed 
Do Until Timer > Delay 
DoEvents 
myCell.Interior.ColorIndex = newColor 
Loop 
Start = Timer 
Delay = Start + fSpeed 
Do Until Timer > Delay 
DoEvents 
myCell.Interior.ColorIndex = xlNone 
Loop 
x = x + 1 
Loop 
Application.StatusBar = False 
Application.DisplayStatusBar = Application.DisplayStatusBar 
End Sub

No	Macro Name
1	background flashes
2	Background of cells "a1: m8" flashes
3	The background of cells a1: m8 flashes
4	excel operators hk
5	Adds cells with red background color between cells A1: d20
6	dyes empty cells between cells a1: a10
7	dyes empty cells between cells a1: a10
8	Calculate the sum of cells with only a certain cell color
9	change the background image then do none
10	give background color by number on active sheet / page2
11	collects selected fields in status bar
12	give background color by number on active sheet / page
13	watermark printing (faded font on sheet / page background)
14	a lot of dialog windows
15	Change the background colors of selected cells
16	empty cells become green
17	Set Background Image Dialog Window
18	Opening internet explorer in Excel
19	numeric code of the background color of the cell
20	Cells Colorful Flashes

Excel Free Macros (VBA)

Background Flashes

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords