Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two drop down lists.
1. user selects Yes or No in cell A2 2. If user selects Yes then cell B2 allows user to select from a list of 4 items 3. If user selects No then cell B2 should be blank as the user does not need to enter anymore information. I was able to create the dependent drop down list if user selects Yes, but not sure how to have the blank when user selects No. Thanks! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
basicly you would set up a "blank list" for you second options. see this site for details. http://www.contextures.com/xlDataVal02.html regards FSt1 "Shacks" wrote: I have two drop down lists. 1. user selects Yes or No in cell A2 2. If user selects Yes then cell B2 allows user to select from a list of 4 items 3. If user selects No then cell B2 should be blank as the user does not need to enter anymore information. I was able to create the dependent drop down list if user selects Yes, but not sure how to have the blank when user selects No. Thanks! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you, but if the user selects yes and then chooses an item from the
list, but then changes their selection to No I would like the dependent list to revert to blank. "FSt1" wrote: hi basicly you would set up a "blank list" for you second options. see this site for details. http://www.contextures.com/xlDataVal02.html regards FSt1 "Shacks" wrote: I have two drop down lists. 1. user selects Yes or No in cell A2 2. If user selects Yes then cell B2 allows user to select from a list of 4 items 3. If user selects No then cell B2 should be blank as the user does not need to enter anymore information. I was able to create the dependent drop down list if user selects Yes, but not sure how to have the blank when user selects No. Thanks! |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
validation doesn't exactly work that way. you will need something extra. right click the sheet tab that contains your validation. from the pop up, click view code. paste this code into the code window. Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Range Set r = Range("A2") If Intersect(Target, r) Is Nothing Then Exit Sub Else If r.Value = "no" Then r.Offset(0, 1).Value = "" End If End If End Sub this will check if the selection has changed and if "no", clear B2. Regards FSt1 "Shacks" wrote: Thank you, but if the user selects yes and then chooses an item from the list, but then changes their selection to No I would like the dependent list to revert to blank. "FSt1" wrote: hi basicly you would set up a "blank list" for you second options. see this site for details. http://www.contextures.com/xlDataVal02.html regards FSt1 "Shacks" wrote: I have two drop down lists. 1. user selects Yes or No in cell A2 2. If user selects Yes then cell B2 allows user to select from a list of 4 items 3. If user selects No then cell B2 should be blank as the user does not need to enter anymore information. I was able to create the dependent drop down list if user selects Yes, but not sure how to have the blank when user selects No. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation-Dependent Lists | Excel Discussion (Misc queries) | |||
Data validation dependent lists | Excel Discussion (Misc queries) | |||
dependent lists on data validation | Excel Discussion (Misc queries) | |||
Data Validation and Dependent Lists Q | Excel Worksheet Functions | |||
Dependent List- Data Validation | Excel Worksheet Functions |