Can't see drop down list in Excel VBA

I've created a very simple drop down list in excel. It holds a sequence of integers loaded from a cell range (years). I need to read the selected value in vba. However I can't even seem to find the control!

I've tried


etc. etc.

From everywhere in VBA this control just doesn't exist. All the tutorials I find seem to assume that using just the control name will work.

I've tried the code in the sheet itself, the workbook, and a module, no luck.


If you got the drop down from the Forms toolbar, use


The DropDowns property is unsupported/deprecated so you won't get intellisense, but it still works.

If you got the drop down from the Control Toolbox, then


should work

There are two kinds of control sets used by Excel. The built-in controls and Microsoft Forms 2.0 controls. The built-in controls available through the Forms toolbar are controls specifically designed to work within Excel and use ranges. The other controls are the Microsoft Forms 2.0 controls. These are ActiveX controls that are used by Office VBA. The are designed to work within Office and are more similiar to the controls used by Windows.

Need Your Help

Java Socket File Corrupt after Finish Transfer

java file sockets corrupt

I am having problems with the following code. The server receives a corrupted file and I do not know why. This is my code..

Java -Xms initial size effects

java memory garbage-collection heap

What is the benefit of setting the -Xms parameter, and having the initial memory larger for example, then the default calculated one (64 MB in my case, according to Java GC tunning: