Data validation with validation lists and combo boxs
 

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?

Data validation with validation lists and combo boxs
 

Hi Keith

I had a similar problem a while back, where I was getting a problem, and
Debra wasn't.
After a lot of investigation, I found that in my VB Editor with my file
active, under
ToolsOptionsGeneral Break on all Errors was set.

Changing this to Break on Unhandled Errors and everything worked exactly
as it should.

--
Regards

Roger Govier


"Keith" wrote in message
...
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?