Hi,
I have data in Sheet2 range A2:B11
In column A I have countries in column B I have fruit.
Example.
France Apples
Italy Apples
France Berries
Spain Cherries
Guatemala Bananas
Italy Pears
France Grapes
Italy Grapes
France Pears
Spain Apples
I would like to create a Userform in Sheet1 where I put the name of a country and after clicking search command button on Userform this gives me list of fruit for that specific country. List of fruit should appear in Sheet1 starting from cell A1.
I have no problem creating Userform but do not know how to trigger search event when I click command button on Userform.
Thanks,
Nix
Bookmarks