As several entries I have seen here I got help from the site
http://www.contextures.com/excelfiles.html I downloaded the example
datavalcombobox.

I followed the instructions and copied and pasted the code from the example
to my copy.

It works with one small problem. When I click onto a different cell the
combo box dosn't completely dissappear. But it does on the downloaded
example. If I click onto the example workbook then back to my one the
combobox is gone. It's like the screen isn't refreshing properly on my
version, but it does on the example.

Any reason why this is happening?