Use of Drop Down -- A New Beez question
 

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

Use of Drop Down -- A New Beez question
 

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

--
Regards.
Tom Ogilvy

"aynang " wrote in message
...
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.

Aynang


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

Use of Drop Down -- A New Beez question
 

Tom,

Thank you. That is very useful.

Aynan

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