Collapse the table of content
Expand the table of content
Expand Minimize

Application.FindFormat Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Sets or returns the search criteria for the type of cell formats to find.

expression .FindFormat

expression A variable that represents an Application object.

In this example, the search criteria is set to look for Arial, Regular, Size 10 font cells and the user is notified.

Sub UseFindFormat() 
 ' Establish search criteria. 
 With Application.FindFormat.Font 
 .Name = "Arial" 
 .FontStyle = "Regular" 
 .Size = 10 
 End With 
 ' Notify user. 
 With Application.FindFormat.Font 
 MsgBox .Name & "-" & .FontStyle & "-" & .Size & _ 
 " font is what the search criteria is set to." 
 End With 
End Sub
© 2016 Microsoft