Data validation listbox still not working after troubleshooting

  • Thread starter Thread starter Arnold
  • Start date Start date
A

Arnold

Hi All,

The list box in each cell in ranges I've named are not working--only
the top cell or record in the list box can be used for some reason.
The list box, when clicked, does not even show the top value--just a
blank field. Does anyone know why this would happen?

It does not appear to be associated with: XP, corrupt wkbook, frames
or window split, etc. I've searched this site and cannot find an
answer. This boggles my mind...

Thanks,

Arnold
 
Hi

How did you define your data validation list? Did you enter values directly,
or did you refer to some cell range on same sheet, or did you refer to some
named range? What have you in Source field, when defining data validation
list?


Arvi Laanemets
 
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

Similar Book to Book Code, one works other does not 11
Data Validation 1
Why would a Data Validation Listbox show all records during a Filter? 5
Access Cannot select items in listbox 1
Data Validation - Drop down when cell is blank 1
Data Validation 14
Multi-select list box 1
Data validation 2

Back
Top