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

--
Message posted from http://www.ExcelForum.com