Drop Down List

[southike]

My work has an excel sheet that we upload to our core system. The sheet has to be in a very specific format. One column is for "account number". I want to create a drop down for the user, but if the drop down merely shows the account number, that does not help them. They need to be able to see the description of the account number as well. For example: 222333444 means nothing to them since they don't have all account numbers memorized. But if the drop down shows "222333444 Insurance Fees", then they would know which account number to select. However, the cell/column can be ONLY a number. It can't include the wording or the upload will fail. Any help is appreciated. Maybe a drop down is not the answer. Thank you.

 

[southike]

Seems like it's close. But when I type something in one of those two cells, I'm getting the attached error message below:

 

[Akuini]

Seems like it's close. But when I type something in one of those two cells, I'm getting the attached error message below:

It looks like you missed an END IF:

                    If Not c Is Nothing Then
                        Target = v
                    Else
                        If Intersect(Target, Range("A2:A3")) Is Nothing Then
                            MsgBox "Wrong Entry"
                            Target.ClearContents
                        End If  '<-- you missed this
                    End If

 

[southike]

Yes, I did. Thanks so much. It works perfectly now.

 

[Akuini]

You're welcome.