Can Select Case be used to defined the Value of an item in a drop down list?

Guessed · #10 10-08-2020, 04:22 AM

Great, did you find how to link both the dropdown and plain text CC to the same xml node so that the value displays in the plain text CC and reflects the value of the dropdown CC entry? This avoids the need for vba to connect the two. You will still need vba for the dependent list of Snr Ops but it does simplify things.

Getting the CC by its Title or Tag is

Code:

ActiveDocument.SelectContentControlsByTitle("TLName")(1).Range.Text = strDetails

'You can also do it by Tag
ActiveDocument.SelectContentControlsByTag("TLName")(1).Range.Text = strDetails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto create new worksheet when select option from drop down list	JANET JONG	Excel Programming	1	08-01-2018 07:13 AM
Select multiple items from a drop down list	ConfuddledOne	Excel Programming	0	01-30-2017 08:13 PM
Returning a specific value when item is selected from a drop-down list	J Press	Excel	4	09-10-2012 06:12 AM
Show the first item of a drop-down list instead of a blank	Pragabhava	Excel	1	12-29-2011 11:48 PM
Automatically select first item in drop-down?	flackend	Excel	4	08-29-2011 02:07 PM