printing list selection

[dorokhin]

Hey everyone!

I'm trying to format a report that has a list (plain old data->list->create list). The user selects what regions and markets he wants to see a report for.

When he goes to print the report I'd like to include a couple lines at the top that say:

Regions Selected: x
Markets Selected: b

How do I pull the list selection and make a cell display the selection (eg: there are regions x,y,z on the report but the user selected to only see x). i want him to remember this when he looks at a paper copy of the report)

Thanks for your help!

 

[dorokhin]

so far the only idea I have to work with is naming the columns of the list and using vba to display the resulting values in a cell. not quite sure how to do this correctly though