Note: Once you change the font using VBA, you cannot undo the changes using the Undo button. So you can set the Font.Bold property of the characters in your search string using the line: m圜ell.Characters(WorksheetFunction.Find(searchString, m圜ell.Value), Len(searchString)).Font.Bold = True You can use this Characters object to format specific characters within the cell.
The Characters object represents a range of characters within the cell ( m圜ell). We then used this information (starting and ending position of the search string) inside the Characters object. To get the ending position of the string we used the length of the search string itself ( Len(searchString)). This gives the starting position of our search string. This means “ return the position of searchString in m圜ell.Value”. WorksheetFunction.Find(searchString, m圜ell.Value) The Find function lets you find a search string in another given string and returns the position of the string in the cell’s contents. That means, the WorksheetFunction.Find function works the same way as Excel’s FIND function. So you can use the functions under this object the same way you would use regular functions in Excel. The WorksheetFunction object is used as a container for Excel worksheet functions that can be used in VBA. If it did, then we used the WorksheetFunction.Find function to find the starting and ending position of the search string in the cell’s contents. We then used a for-loop to traverse over each cell ( m圜ell) in the range and we checked if the cell contained the search string. We used an InputBox to get the user’s search string input and we stored this text in the variable searchString. In this code, we stored the selected range of cells in the variable Rng. In our example, we entered the word “ King”. Type your search string in the input box.
How to Find and Bold Specific Text in a Cell using VBA
If it did, then we made the contents of the cell bold. We then used a for-loop to traverse over each cell ( m圜ell) in the range and we checked if the cell contained the search string (using the InStr function). In this code, we again stored the selected range of cells in the variable Rng.
In our example, we entered the word “King”.