Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation drop down list format
Hi, I created a data validation range that users enter information into to
create the drop down list. The user does not need to enter information into all cells in the range. I use the result of the information to generate effort, duration, and resource usage for copying to MsProject so the blank fields in the range must not generate results. The problem is that the drop down list doesn't read from the top unless all cells contain information. Does anyone have ideas on how to format the list to show from the top regardless of the empty cells? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation drop down list format
Hi,
Data Validation lists will show spaces if their source range has spaces, you might get around this by using a combo box control and VBA. You might try http://www.contextures.com/xlDataVal01.html as a starting place for some ideas. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Pwinkle" wrote: Hi, I created a data validation range that users enter information into to create the drop down list. The user does not need to enter information into all cells in the range. I use the result of the information to generate effort, duration, and resource usage for copying to MsProject so the blank fields in the range must not generate results. The problem is that the drop down list doesn't read from the top unless all cells contain information. Does anyone have ideas on how to format the list to show from the top regardless of the empty cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation with Drop-down list | Excel Worksheet Functions | |||
Data Validation Drop-Down List | Excel Discussion (Misc queries) | |||
DROP DOWN LIST DOES NOT APPEAR USING DATA VALIDATION | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
data validation list drop down text format too small | Excel Worksheet Functions |