First of all, I link cell A1 of Sheet 1 to a Combo Box whose list contains a series of strings. Now after I pick one of the strings from the Combo Box's list, I want to use VBA to find all the cells in Sheet 2 that contain strings matching the one I selected from the Combo Box list. How do I this?
I am aware of the Cells.Find function:
Cells.Find(What:=, After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , MatchByte:=False, SearchFormat:=False).Activate
I tried to specify Cell A1 of Sheet 1 after the "What:=" line above but VBA keeps giving me error messages. Is there a workaround?