Is it the most practical way to go at it, and if so, how will I
retrieve each keyword ?
Second Step :
I then want to search column A for the occurence of a minimum of 2 of
those keywords,
and if found then display the entire row on Sheet2.

1. Column A Test Data Column B remarks.....
2. Applle, Cherry, Pear
3. Orange, Peach, Lemon
4. Lemon, Mango, Cherry
5. Cherry,Kiwi, Lemon

Keyword string from InpuBox : Lemon, Pear, Cherry
Row 4 and 5 should be returned.

Pseudo Code
Enter keywords string
Extract Keywords and number of (2 or 3)
Retrieve LastRow of Data
Relevance = 0
For Row 2 to Last Row in Column A
If First Keyword is found then Relevance = 1
If Second Keyword is found then Relevance = Relevance + 1
If number of Keywords is 3 and if Third Keyword is found then
Relevance = Relevance + 1
If Relevance 1 then write entire Record to Sheet2 with
Relevance value in Column D
Relevance = 0
Next Row

Help appreciated,
J.P.