DropDown control problem [Excel 2007]

sektor · May 13th, 2009, 06:20 AM

I wrote code which creates and fills DropDown control when I double-click a cell (page 215).
It works fine in Excel 2007 with English UI, but it when I switch to Russian UI, then I get the following error (translation from russian to english):

Runtime error '1004': Unable to get DropDowns property of Worksheet.

Here's the code (the line with "With ActiveSheet.Dropdowns" is highlighted by compiler):

Code:

Private Sub GetWorkerName()

    ' Enter selected item into cell beneath DropDown.
    With ActiveSheet.DropDowns(Application.Caller)
    '......................
    ' Delete DropDown.
     .Delete

    End With
    
End Sub