Userfom event

**nicolaforni** · 08-23-2011, 10:07 AM

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

**Bob Phillips** · 08-23-2011, 10:28 AM

Please Login or Register  to view this content.

**Mordred** · 08-23-2011, 10:43 AM

Hi nicolaforni, I've attached a button that loads a user form and then does what you want (I think). Let me know how it goes.

**nicolaforni** · 08-23-2011, 12:54 PM

Great thanks!
Nic

**tigeravatar** · 08-23-2011, 12:56 PM

nicolaforni,

Throwing in my 2 cents. For something this simple, a userform isn't requried. Essentially all you want is a drop-down list that returns results. Attached is an example workbook that does just that. I threw in some bells and whistles to make it fancy, but essentially, pick an item from the drop-down list in Sheet1 B1, and the results will be returned starting in B2. The code is in Worksheet_Change events and the drop-down list is a data-validation.

Hope that helps,
~tigeravatar.

**nicolaforni** · 08-24-2011, 12:45 PM

Thanks tigeravatar that is also useful.

Mordred one final thing how would I change code to show not the whole rows (eg. Italy Apples, Italy Pears etc.) but simply what is in a specific column for that country so in this case in column B?

Thanks,
Nix