If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|