Use of Drop Down -- A New Beez question

[aynang]

Hi,

I need to finish a Excel macro but I am pretty new (not in MS
shop). Here is what my boss wants.

In a worksheet, lay out 2 x n Drop Downs in two columns
on two rows. The selection of first Drop Down drives the
creation of the content of the second Drop Down.

My question here.

(1) How can I relate a cell (row, column) to a
Drop Down that resides on this position?

(2) How can I access / manipulate a Drop Down on a
Worksheet?

I tried something silly like ActiveSheet.Drop Down 1.Value
but it is not recognizable by VB.

Thank you so much.

Aynan

 

[Tom Ogilvy]

See Debra Dalgleish's site on using Data=>Validation with the List option:

Dependent lists - data validation
http://www.contextures.com/xlDataVal02.html


Datavalidation - top
http://www.contextures.com/xlDataVal01.html

 

[aynang]

Tom,

Thank you. That is very useful.

Aynan