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