View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
William DeLeo
 
Posts: n/a
Default Use dd menu choice to filter input for next ddm, etc.


Greetings,

I'd like to set up a form with several drop down menus. The form will
be designed to search for and pull up a particular record (row on a
worksheet) for editing (I just need to identify which record needs to
be edited with this form).

I'd like the user to step through maybe 3 ddms, with the selection of
ddm1 applying a filter and limiting the options of ddm2 (and similarly
for ddm2 and ddm3). For example, if ddm1 chooses a date, then the
options for ddm2 would only correspond to the records with that date.

I can go formula and/or VBA for this, but I'm not sure how to start.

Any direction would be greatly appreciated.

TIA
WD


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=550457