Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for. Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
Sub highlightValue()
Dim myStr As String
Dim myRg As Range
Dim myTxt As String
Dim myCell As Range
Dim myChar As String
Dim I As Long
Dim J As Long
On Error Resume Next
If ActiveWindow.RangeSelection.Count> 1 Then
myTxt= ActiveWindow.RangeSelection.AddressLocal
Else
myTxt= ActiveSheet.UsedRange.AddressLocal
End If
LInput: Set myRg= Application.InputBox("please select the data range:", "Selection Required", myTxt, , , , , 8)
If myRg Is Nothing Then
Exit Sub
If myRg.Areas.Count > 1 Then
MsgBox"not support multiple columns" GoToLInput
End If
If myRg.Columns.Count <> 2 Then
MsgBox"the selected range can only contain two columns "
GoTo LInput
End If
For I = 0 To myRg.Rows.Count-1
myStr= myRg.Range("B1").Offset(I, 0).Value
With myRg.Range("A1").Offset(I, 0)
.Font.ColorIndex= 1
For J = 1 To Len(.Text)
Mid(.Text, J, Len(myStr)) = myStrThen
.Characters(J, Len(myStr)).Font.ColorIndex= 3
Next
End With
Next I
End Sub

No	Macro Name
1	Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for.
2	excel operators hk
3	Count / Highlight Cells with a Specific feature on the entire worksheet: This code will help you count the cells that have a specific value to mention, and then highlight all of those cells.
4	Multiply All Values by Number: You have a list and you want to multiply the entire number by a specific number. Just use this code. Select this range of cells and run this code. first, it will ask you the number you want to reach more than one person, and then all their numbers will be multiplied instantly.
5	specify partition, list how many files you have
6	Highlight Over Values Highlight: After running this code, you will want the value you want to highlight all larger values.
7	Remove One Character from Selection: You can use this code to remove a specific character from a selected cell. It will display an input box to enter the character you want to delete.
8	Print Custom Pages: You can use this code to print a range of custom sheet / pages instead of using the setting from the print options. Suppose you want to print sheet / pages 5 to 10. Just run this VBA code and enter the start sheet / page and end sheet / page.
9	remove sheet / page protections
10	Highlight Less Than Values: After running this code, you will want the value for which you want to highlight all low values.
11	search color
12	Custom Header / Footer: This code is for you if you want to add a custom header. In the Run this code entry box, enter a custom value. you can edit the code to change the alignment of the header or footer.
13	opening calculator
14	Hide or show pivot table fields according to a specific criterion
15	Highlight replicators from selection: This macro controls each cell of your selection and highlights duplicate values. You can also change the color of the code.
16	write the number you want to be colored on the sheet / page in msgbox
17	Find and select the remaining cell in the value between 2 selected numbers
18	get information from the registry
19	Add Multiple Worksheets: you can use this code if you want to add multiple worksheets in a single point in your workbook. When you run this macro code, you receive an input box to enter the total number of sheet / pages you want to enter.
20	Adding Serial Numbers: This macro code will help you automatically add serial numbers to your excel sheet. After you run this macro, it will display an input box where you must enter the maximum number for serial numbers, and then add a number to the column in a column.

Excel Free Macros (VBA)

Highlight Specific Text: Suppose You Have A Large Data Set And Want To Control A Specific Value. You Can Use This Code For This. When You Run, You Receive An İnput Box To Enter The Value To Search For.

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords