R
Richhall
Hi
I am trying to search within Excel VBA a value in a sheet dependant on
the entry in another cell. But not sure how to put a paramater as the
What part of the Find.
Can anyone help please?
i.e if cell A1 is Cat then I would search for Cat in the other sheet.
Dim Animalname
AnimalName = Combo1.Value
Sheets("Animals").Select
Cells.Find(What:=Animalname,After:=ActiveCell, LookIn:=xlFormulas,
LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate
I am trying to search within Excel VBA a value in a sheet dependant on
the entry in another cell. But not sure how to put a paramater as the
What part of the Find.
Can anyone help please?
i.e if cell A1 is Cat then I would search for Cat in the other sheet.
Dim Animalname
AnimalName = Combo1.Value
Sheets("Animals").Select
Cells.Find(What:=Animalname,After:=ActiveCell, LookIn:=xlFormulas,
LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate