Combo Box & USerform

[hce]

Hi

Can someone be so kind to teach me how I can utilize the combo box?

For eg, I have a database of contacts in Sheet1... and I have created
combo box in which it has all the contries listed in the database... fo
eg... Australia, Europe, USA, etc...

If the user chooses Australia, how can I write a macro to take thi
value and then filter the database in the "country" column to show onl
Australia?

And if the user selects a country which has no contacts in th
database, an error message will pop up to say that there's no contact
for this country...

I believe the above is possible using vb code but i hav
forgotten/returned whatever i have learned in vb 5 years ago back t
the lecturers...

Can anyone kindly help to give some suggestions...?

will really appreciate it...

cheer

 

[Dave Peterson]

Why not just use excel's built-in Data|filter|autofilter.

If the users learn how to filter by one column, they may even find that they can
filter by others and it'll be really useful.