Script to select from a Data Validation dropdown

[lewisthelemon]

Hello, I am trying to generate a macro to select a particular name from a dropdown list. i tried using the record macro function, but the result was just a range.select
Is this possible? Thanks in advance

 

[Kamolga]

I recorded a dropdown list my MyDefinedname and it worked.

 With Selection.Validation
        .Delete
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:="=[COLOR=#0000ff]MyDefinedName[/COLOR]"
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True
    End With

 

[lewisthelemon]

@Kamolga Thank you for the reply.
My question may not have been clear. What I was asking is how to select the name from an already created list. I found a round-about way to do it, below is the code. If you could suggest any improvements it would be nice:

Sub Macro1()


Worksheets("Sheet1").Activate
With Worksheets("Sheet1")
    If .Range("B1").Value = "Costs" Then
        .Range("A1").Value = "FTE"
    Else
        .Range("B1").Value = "Range"
    End If
End With
End Sub