DropDown control problem [Excel 2007]

sektor · May 13th, 2009, 05:59 AM

I have code (taken from Excel 2007 VBA Programmer's Reference) which creates and fills DropDown control when I double-click a cell.
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