need help in the coding of a searchcommand, I have some data on the spread sheet and need the searchcommand to read from the form and locate and highlight the particularentry...on the spread sheet, Can you pliz help me with this coding?
Suppose you want to search for the word "test" in a worksheet containingseveral words in each cell then this code will search for the word "test"starting from the first cell and highlight it with a yellow color.Sub SearchText()Range("A1").SelectCells.Find(What:="test", After:=ActiveCell, LookIn:=xlValues).ActivateActiveCell.Interior.ColorIndex = 6End subThis is just the tip of the iceberg as a lot can be done like multiplesearches and so on.This code can be tied to a button which you can keep on your worksheet. As youpress this button the text will get highlighted by itself.