Thread: Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
Posts: 487
Default Validation

I have set-up Validation for use in four locations in my "form" spreadsheet;
sheet 1 is the form; sheet 2 & 3 contain the ranges for the drop down lists;
all works ok, except----
1) all four ranges produce a drop down list in which the fonts are very
small and almost unreadable; changing the font in the range does not help
2) the drop down for the range that contains 50 rows ( only 10 actual
entries so far-these are client names and this list will increase) starts at
random rows in the list-in the middle, at the bottom, but never at the top of
the list; the other three ranges, each containing only two, three or four
entries, always start at the top of the list.

help, help??
--
Don