Validation List Criteria

[cshipley]

Is there a way to get around the limited number of characters that can be entered in the 'Source' field when trying to create a Validation List for a cell? I am about 30 characters short for the function I am trying to enter.

Thanks

[VBA Noob]

Prehaps make your list on a seperate sheet and then hide the sheet with the list

http://www.contextures.com/xlDataVal05.html

VBA Noob

[cshipley]

My list is already coming from another workbook. What I need to enter in the 'Source' field is an 'IF' statement that changes what is shown in the drop down list depending on what is entered in the previous cell. My problem is the 'Source' field doesn't allow enough characters for what I need.

Thanks

[VBA Noob]

Prehaps this will help

http://www.contextures.com/xlDataVal02.html

VBA Noob

[cshipley]

Thanks VBA Noob, I think I can make that work.