Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default Drop down menu with validation that requires Marco

Hi,

Here are the steps for creating a dynamic data validation list:

1. Create three or more list in the spreadsheet. For example:
A B C
New York Quebec Canada
Seattle Toronto US
Miami Victoria

You would name lists: US (A1:A3), Canada (B1:B3), Countries (C1:C2) this
last is optional

2. Select the cell where you want the initial validation list, for this
example, D1
3. Choose Data, Validation
4. From the Allow drop-down and choose List
5. In the Source box enter the following formula
=Countries
6. Move to the location where you want the dynamic (changing) list to
appear, say for example E1
7. Choose Data, Validation, List and in the Source box enter the formula
=INDIRECT(D1)

You can also make a self-referential dynamic data validation list.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"ssi141" wrote:

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

Reply
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 07:42 PM
Drop down menu and validation over mulitiple sheets NFaye Excel Worksheet Functions 4 January 24th 08 11: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 05:19 PM
How do I set up a drop down menu for a validation list? UisNike Excel Worksheet Functions 2 December 29th 04 08:13 PM


All times are GMT +1. The time now is 10:24 PM.

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

About Us

"It's about Microsoft Excel"