Drop Down Menu Editing

**moericus** · 01-25-2007, 03:42 PM

Hello,

I can't figure out how to change an existing drop down menu in one of the company's spreadsheets. The menu contains a list of initials. When the initials are picked the cell value is changed to a number. The number is then matched with a numbered list on another sheet for more specific information.

I want to know how drop down menus can set cells equal to a different but corresponding value. Also, how can I change the setup or list on an existing drop down menu.

Thanks,

Eric

**VBA Noob** · 01-25-2007, 04:21 PM

Hi,

There might be a event macro at work. Right click the sheet tab with the data validation. Select view code. Paste in the below

Then change to your condtions. In my example if you type FT into A1 it changes it to 10

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Select Case Range("A1").Value
          Case "FT"
              Range("A1").Value = 10
          Case "CL"
              Range("A1").Value = 40
          
    End Select
End Sub

This link has everything you need to know about Data validation

http://www.contextures.com/xlDataVal01.html

VBA Noob

**moericus** · 01-25-2007, 04:43 PM

I just spoke with someone here. The numbers are generated by using format control. Format control aparently assigns a number starting at one for the given list.

But, I still don't understand how this type of drop down menu was created.