Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of Drop Down -- A New Beez question
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanded Drop Down Box Question | Excel Discussion (Misc queries) | |||
Drop down list question | Excel Worksheet Functions | |||
Drop Down Question | Excel Discussion (Misc queries) | |||
Drop down list question | Excel Discussion (Misc queries) | |||
A Drag drop question | Excel Programming |