Data validation with validation lists and combo boxs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Tools>Options>General> Break on all Errors was set.

Changing this to Break on Unhandled Errors and everything worked exactly
as it should.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data validation and combo box 4
Combo Box 2
Validation rule for Combo Box 0
Appearance of Data Validation Combo Box 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation - combo box 4
Problem with Data Validation 1
Combo Box / Hard Coded List 1

Back
Top