View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rone[_2_] Rone[_2_] is offline
external usenet poster
 
Posts: 4
Default Validation List Box Locked

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?
--
Rone