Select name in dropdown

[Ramachandran]

If I want to get the (string) value of the select item in the dropdown, that's allright:

With Worksheets("Registrering").Shapes("Drop Down 1").ControlFormat
name = .List(.Value)
End With

But I want to go the other way, selecting the listindex from the string value,
If I do this:

With Worksheets("Registrering").Shapes("Drop Down 1").ControlFormat
.List(.Value) = namn
End With

I will overwrite listindex = 1...

 

[Ramachandran]

If I run the last code, the drop down(Forms Combobox) will show the name.value, but it will overwrite whatever the previous selected value was.
The name.value is already added to the dropdown, I simply want to programmatically select it.
Anyone who can help?

 

[Ramachandran]

With Worksheets("Registrering").Shapes("Drop Down 1").ControlFormat
i = 0
Do
i = i + 1
Loop Until .List(i) = name Or i = .ListCount
.ListIndex = i
End With

This works, so I'm happy. But please do let me know if there is any other solution.

 

[Kyle123]

like this:

With Worksheets("Registrering").DropDowns("drop down 1")   
    .Value = Application.Match(name, .List, 0)
End With