Drop Down Lists

[jthomas24]

Hello

I am creating a file where I want to set up a data validation list. So i was able to create the drop down list that represents a bunch of names in a certain format. in the list there is the option to select "Other". when the user selected "other" i want a input box to pop up that will allow the user to input some other value and than put it in the text box.

Is that possible?

 

[Roderick_E]

Something like:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$CP$3" And Target = "other" Then
inbx = InputBox("Define other")
End If
End Sub

 

[FDibbins]

You can set up the DD to allow "non-listed" entries. In the Error Alert tab, select Info or warning, you will be allowed to enter anything you want