Validation List Box Locked

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

Guest

Hey Guys...I need some help. I was in the middle of programming a workbook
to auto populate a cell with a validation list box data. It was working just
fine and I was stepping through the code in debug mode. I don't know what
happened, the code didn't change (at least I can't see where it might have
changed). Now when I click on the cell to bring down the validation drop
list it acts like the cell is locked and won't bring down the data.
Although, the dropdown arrow shows up. I looked in the list and there are
values that should show up, I just can't get to them.

How can I fix this?
 
Just a guess.

Are you using xl97?

Did you apply window|freeze panes?

If yes to both of these, remove the freeze panes. It's been fixed in xl2k.
 
Are you using a named list? Did the list name change, or is it spelled
incorrectly in the code?
 
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 List (conditional) 2
How to automatically show list in a validation list? 5
problems when removing validation 1
Conditional Validation In Excel 1
get Data Validation to stop, list supplied, duplicate data entries 1
Alternative to Data Validation (List) 3
Validation Drop Down 2
autofilling a cell as the user types 1

Back
Top