Dynamic Populate Content Control XML

[DangerDraper]

Hi all,

Looking for assistance here with getting this done in XML. I need to find a quick and VBA-free (macros are disabled by default on project) method for populating a series of comboboxes and then (hopefully) make them dynamic of each other.

Originally this used to be an Access db and a series of forms (on a similair project) but they've now phased out access. Which wouldn't be a problem with Office 19/365 as I could use the dynamic arrays features in excel... Unfortunately they're using a mix of Office 13/16.

Basically the three combos represent a different column in a table and the tables is approx ~50 lines deep. And the form will be based off aprrox 10-15 similiar sized tables.

Me being too lazy to manually populate each CC, I had hoped that I could pull these lists into the CC via a custom XML Add-in.

I had thought either of the two would work... but the xml doesn't bind to the CC

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<!--<xmlns="Data Scaveneger"/>-->
<DataScavenge>
	<Common>
		<UniqueID></UniqueID>
		
		<systemName>
			<item>
				<system>Air Conditioning</system> 	
				<system>Cooling Water</system> 	
				<system>Cold Water</system> 	
				<system>Hot Water</system> 	
			</item>
		</systemName>
		
		<pscName>		
			<psc>AirCon</psc>		
			<psc>CoolWtr</psc>
			<psc>CldWtr</psc>
			<psc>HotWtr</psc>
		</pscName>
		
		<TSC></TSC>
		
	</Common>
	
	<Section1></Section1>

</DataScavenge>