Automplete Combobox with Dynamic Lists

[swagatkarnany]

I use Excel 2007 and tried creating Auto Complete combo boxes using the example shown here http://www.contextures.com/xlDataVal10.html.

Now in the example if i type "ju" and click on the drop down I should have the value "june" selected but that does not happen but according to the example this is what the code is designed for is there anything which I am doing or understanding wrong?