Perform action based on choice from validation list

Hi. I need help with VB code for this. In all the cells in column F I have a validation list with several predefined choices, but at the bottom of this list I want an "Other..." option, which when chosen, enables the user to enter a new string in that cell if none of the predefined did not match.

Thanks in advance.

You may not need VB code for what you're asking...

Data Validation allows you to present a list, but accept unlisted items.
Example:
Cells D1:D7 contain the list:
Alpha
Bravo
Charlie
Delta
Echo
Foxtrot
Golf

Select cell A1
Data.Validation
...Allow: List
...Source: =$D$1:$D$7
Select the Error Alert Tab...
...Style: Warning
...Title: Please confirm
...Error message: Item is not on the list. Accept the item anyway?
Click OK

With those settings, A1 will have a drop down list, but if a user simply enters
an unlisted value, a confirmation to accept that value is displayed.

Is that something you can work with?

Hi,
I 'm not very clear on your requirement.
But tried to help,

Please Login or Register  to view this content.

Hope this helps.

I just need to know how I can "fire" the applicable function based on the users choice.

You can use the Worksheet_Change event.

For more info. on Events see: http://www.cpearson.com/excel/Events.aspx