IF function and a drop down list validation.

[Stevie-B]

Hi all,

I wish to enter an IF function that will automatically select an option within a small drop down list that I have created.

When a user enters a date into say cell A1 I want the drop down list to select the option "Ongoing" in cell C1. I also still want the user to change the drop down list options if they so wish?

Any ideas anyone..... thanks.

[Portuga]

You can either have a cell where you can select data(from drop down or manual) or a cell with a formula. You cant have it both ways.

This said, you can apply the formula

If (a1=whatever;"ongoing";"").
This will work untill somebody chooses the value from the dropdown list, in this case the formula will disappear.

[davesexcel]

Hi all,

I wish to enter an IF function that will automatically select an option within a small drop down list that I have created.

When a user enters a date into say cell A1 I want the drop down list to select the option "Ongoing" in cell C1. I also still want the user to change the drop down list options if they so wish?

Any ideas anyone..... thanks.

This code could work,
If you have C1 as your data validation, when you change A1 the code will change C1 to Whatever A1 is, but you will still be able to use your drop down menu.
Place this code in the worksheet module.
right click on the sheet tab and select view code, copy and paste this code there...

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim c As Range
    Set c = Range("C1")
    If Target.Address = "$A$1" Then
        c = Target
    End If
End Sub