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? |
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? |
All times are GMT +1. The time now is 05:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com