Hi, have attached form with vba error. Trying to combine OnExit code.



My preference is to parse dropdown method onexit Content Controls. If I select display value "Fred Smith" I would prefer that the "Email" address is inserted fsmith@gardens.com not display name "Fred Smith" and then "Name" content control is filled in at end of document using "Display value" or parse value "Name". Is this easier.

I altered my parsed listed to be:
Display Value Value
email address fred smith|xxx|xxxx
email address john smith|xxx|xxxx

Would prefer to be able to use below format:

Fred Smith fsmith@gardens.com|Fred John Smith|0555 111 222

When display value is selected the Email address is inserted not the display value in most cases. Then the Name (which is display value in this case) is inserted in "Name" content control at end of document.

What is best approach please?



?



jec

Attached Files

Transcript Order Form LC_Oct 2012 v1.dotm.zip (65.8 KB, 17 views)