LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit Menu will not automatically drop down anymore Irene Pai Excel Discussion (Misc queries) 5 May 12th 11 07:43 AM
Auto Filter - Protected sheet/workbook ronwill Excel Discussion (Misc queries) 3 January 10th 06 03:28 PM
Delete rows based on multiple criterias Benson Excel Discussion (Misc queries) 8 November 2nd 05 03:11 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM
Applying a formula to a drop menu choice Andrew Hill Excel Discussion (Misc queries) 1 January 4th 05 11:05 AM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"