Sub list and rum macros in the function

[Guest]

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?

 

[Max]

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 appear: Texas, Arizona, Florida
when in the cell A1 is Eua.

Try Debra's page at:
http://www.contextures.com/xlDataVal13.html
Data Validation -- Dependent Dropdowns from a Sorted List

Another good source is Bob Phillips':
http://www.xldynamic.com/source/xld.Dropdowns.html
Dynamic Dependent Dropdowns

---