How to create flashing letters on Excel

To create flashing words on Excel, we need to use VBA programming language.

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.

How to create flashing letters on Excel Picture 1How to create flashing letters on Excel Picture 1

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.

How to create flashing letters on Excel Picture 2How to create flashing letters on Excel Picture 2

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.

How to create flashing letters on Excel Picture 3How to create flashing letters on Excel Picture 3

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

How to create flashing letters on Excel Picture 4How to create flashing letters on Excel Picture 4

Step 4:

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

How to create flashing letters on Excel Picture 5How to create flashing letters on Excel Picture 5

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.

How to create flashing letters on Excel Picture 6How to create flashing letters on Excel Picture 6

Step 5:

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

How to create flashing letters on Excel Picture 7How to create flashing letters on Excel Picture 7

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.

How to create flashing letters on Excel Picture 8How to create flashing letters on Excel Picture 8

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.

How to create flashing letters on Excel Picture 9How to create flashing letters on Excel Picture 9

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

How to create flashing letters on Excel Picture 10How to create flashing letters on Excel Picture 10

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

How to create flashing letters on Excel Picture 11How to create flashing letters on Excel Picture 11

The word results will flash from red to blue.

How to create flashing letters on Excel Picture 12How to create flashing letters on Excel Picture 12

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!

4.2 ★ | 14 Vote