software

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

quot;T-shugoquot; wrote:
gt; 1- I want make a sub list in the excel.
gt; I make the dop down list in the cell A1
gt; contain: Eua, Brazil, Ingland, Canada.
gt; And i want that in the cell B2 appear: Texas, Arizona, Florida
gt; when in the cell A1 is Eua.

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

Another good source is Bob Phillips':
www.xldynamic.com/source/xld.Dropdowns.html
Dynamic Dependent Dropdowns
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---