LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Drop down menu with validation that requires Marco

I try to create a form that contain two cells where cell 1 requires user to
enter information like A or B or C. I am able to use drop down method for
cell 1.
However, the cell 2 require certain validation that relate to information
that entered in cell 1. if User enter A in cell 1, then only the require
information like A1, A2, & A3 shall appear in the drop down menu, likewise if
user enters B or C.

I have little knowledge on Excel, and only get to undertand the drop down
method after asking around. I try to follow the online help on creating the
Macro but fail to understand.

Need your help. Thanks
 
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
Data Validation Drop Down Menu Width Zee[_2_] Excel Discussion (Misc queries) 1 November 4th 08 06:42 PM
Drop down menu and validation over mulitiple sheets NFaye Excel Worksheet Functions 4 January 24th 08 10:12 PM
The drop down menu of my validation list needs to display more. Mr. Hill Excel Discussion (Misc queries) 2 July 31st 07 03:14 PM
Validation- Drop Down menu size bras1l Excel Discussion (Misc queries) 2 February 3rd 06 04:19 PM
How do I set up a drop down menu for a validation list? UisNike Excel Worksheet Functions 2 December 29th 04 07:13 PM


All times are GMT +1. The time now is 05:43 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"