flashing Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub FlashFont() 
'Joe Was 
'Make cell range font flash, x times, x fast, in x color, 
'when Ctrl-z is pressed. 
Dim newColor As Integer 
Dim myCell As Range 
Dim x As Integer 
Dim fSpeed

'Make this cell range font flash! 
Set myCell = Range("A1:AF12") 
Application.DisplayStatusBar = True 
Application.StatusBar = "... Şu an flash yazı gösterisi var lütfen biraz bekleyin...! "

'Make cell font 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 = 3

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

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

'Run loop! 
DoEvents 
Start = Timer 
Delay = Start + fSpeed 
Do Until Timer > Delay 
DoEvents 
myCell.Font.ColorIndex = newColor 
Loop 
Start = Timer 
Delay = Start + fSpeed 
Do Until Timer > Delay 
DoEvents 
myCell.Font.ColorIndex = xlAutomatic 
Loop 
x = x + 1 
Loop 
Application.StatusBar = False 
Application.DisplayStatusBar = Application.DisplayStatusBar 
End Sub 
Sub reSetFlash()

'Re-set cell range color if edit break on color, Ctrl-r to re-set! 
ActiveCell.Select 
Selection.Interior.ColorIndex = xlNone 
End Sub

No	Macro Name
1	flashing articles
2	Cells Colorful Flashes
3	convert double and single lines into different colors and designs (one line is bold and the other line is normal)
4	background flashes
5	Background of cells "a1: m8" flashes
6	The background of cells a1: m8 flashes
7	flashing
8	Â Pivot Table These codes help you make and manage some changes to pivot tables in a flash. Hide Pivot Table Subtotals: If you want to hide all subtotals, simply run this code. first make sure that you select a cell from the pivot table and run this macro.
9	finds formulas on active sheet / page lists new sheet / page
10	list formulas on new sheet / page
11	specifies in detail how many formulas are in the book (on new sheet / page)
12	Data between cells a1: af12 flashes
13	Data between cells a1: af12 flashes
14	Hide or show Excel completely / Hide Excel
15	macro example of continuous flash
16	continuous flash example in excel
17	search combobox change
18	file search 2
19	Find how many formulas are in the selected field and select all cells containing the formula
20	comparison; sheet / page1 sheet / page2 abc columns

Excel Free Macros (VBA)

Flashing

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords