I have 3,000 works in an excel cell in which I need to search for a single word. It does not highlight the word; it only puts me in the cell with the word.
Does anyone know how I can get the highlighted word I'm looking for?
Thank,
Steve
You must change the font / selection / background of the characters that you find using the "Symbols" property in VBA. This can be packaged with the actual search, or you can perform the search manually and the selection with a macro. See this link for sample code http://www.ozgrid.com/forum/showthread.php?t=66197
, Excel, , , .
HTML. , .
, , , , , ?
, :
http://www.mrexcel.com/forum/showthread.php?t=397445
, , " " ( "" ). ( ), , . , "", .
- , MS Word. , .
.csv, , , , , . ?
Word Excel.
, , , , , ( "..." "" ) ( "" " " ). , , " ", , ( "" ).
, , .
Mike
alt-e-f (find), , em
Source: https://habr.com/ru/post/1755548/More articles:Is it possible to write a JSON parser without using recursion? - jsonConvert LINQ query query results to DataTable - vb.netJSlow JS file merging according to YSlow guidelines - optimal size? - performanceDifferences between CAPICOM TripleDES and System.Security.Cryptography TripleDES - c #Synchronize a local SQLite database with SQLite SQL Server - synchronizationHandle Click Event for LinkButton in user control from ASP.NET parent page - asp.netHow to save an image using UIImageWriteToSavedPhotosAlbum after converting it - iphoneIPhone Cost vs. Benefit - OpenGL ES 1.x vs. 2.0 - performanceLINQ Select a specific cell in the DataGridView depending on another cell in the row - c #How to get rgb cimg value? - c ++All Articles