How to create flashing letters on Excel

For those who work extensively with Excel, in addition to advanced Excel functions, VBA and Excel programming languages ​​are also used. VBA on Excel stands for Visual Basic for Application. We use VBA programming language to write macros. Macros are complete programs that automatically execute the commands you have written. And if you want to create a flash text effect on Excel, you need to use this VBA.

With this effect we can highlight certain content in Excel data sheet to readers. In particular, users can change the blinking font color through the code. The following article will guide you how to create flashing letters on Excel.

1. How to break VBA password in Excel
2. How to send email from Excel spreadsheet with VBA script
3. 10 ways to recover corrupted Excel files
4. Forgot password protected Excel file, what should you do?

Instructions for creating flashing letters on Excel

Step 1:

Open the Excel file and press Alt + F11 to open Excel's VBA code.

At the Microsoft Visual Basic dialog box for Applications users click on Insert and select Module as shown below.

Step 2:

Display the Moude interface for you to paste the code below into the interface.

 Sub StartBlink () 
 Dim xCell As Range 
 Dim xTime As Variant 
 Set xCell = Range ("A1") 
 With ThisWorkbook.Worksheets ("Sheet1"). Range ("A1"). Font 
 If xCell.Font.Color = vbRed Then 
 xCell.Font.Color = vbWhite 
 Else 
 xCell.Font.Color = vbRed 
 End If 
 End With 
 xTime = Now + TimeSerial (0, 0, 1) 
 Application.OnTime xTime, "'" & ThisWorkbook.Name & "'! StartBlink",, True 
 End Sub 

Note that you should copy the above code into Notepad and then edit it again The position of the cell and the working Sheet is the position of the text you want to create the flash effect. In the text that is written in cell A1 and in Sheet 1. Users can enter any cell and Sheet that they want.

Press Alt + Q to turn off the dialog box.

Step 3:

In the correct position of the cell and Sheet in the code you have created, enter the content you want to create a flashing effect on Excel.

Click on the Developer tab and then select the Insert item below and click on the Button (Form control) icon .

Step 4:

Draw any square in the Excel interface to make the button activate the blinking effect for the word.

Once you release the mouse button, the Assign Macro dialog box will display. Here the user will need to select 2 items:

1. Macro name: You select StartBlink.
2. Printed Macros: Click This Worknook on the list.

Click OK to save the settings.

Step 5:

To change the text in the new frame, right-click and choose Edit Text .

Enter any content you want into this frame and press Enter to save it. If you want, users can still change the font, the font size for this Button.

The end result when clicking on that button will automatically flash the text according to the color we have set in the code, here is red and white.

In case you want the word flashing green to red, click on the Developer tab and select Visual Basic .

Next change from white (White) to blue (Blue) in the code as shown below. Also press Alt + Q to save this new code.

The word results will flash from red to blue.

Through VBA in Excel, you have added a way to create content highlighting in the data with an automatic blinking effect. Note that we need to enter the correct code, especially the brackets in the code, to avoid error after applying the code.

The video makes the text flash automatically on Excel

I wish you all success!