Do you really need more than 256 characters as a dropdown choice? It'd be impossible for most users to even see the whole of that option...



A better approach would be to have simple options for the users to choose from and automate the display of the corresponding output.

The attached document shows how to do that, employing a ContentControlOnExit macro to display the corresponding text for each item. For items with an output of up to 256 characters, the output text can be stored in the Content Control's 'Value' property. For longer strings it's stored in the macro code itself. You can access the macro code via Alt-F11.

Attached Files

Choose an item.docm (36.8 KB, 11 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]