1- I want make a sub list in the excel.

I make the dop down list in the cell A1 contain: Eua, Brazil, Ingland,
Canada. And i want that in the cell B2 apeard: Texas, Arizona, Florida when
in the cell A1 is Eua.

How I do it?

2- I would like execute a macro into If funtion.

I make a macro that delete a list and I want that in the cell A1 when I
select a option in the drop down list using the If funtion..... If the cell
A1 = deleteA, execute the macro4 that erase the list A.

How I do it?
--
Tiago Gonçalves Brandão