#Collecting DataSource for Combobox
$Check11L = $ImportARMGSpreaders | where {$_.Used -eq "NO"} | select -ExpandProperty Name

$Spreader11L = New-Object System.Windows.Forms.combobox
$Spreader11L.Width = 80
$Spreader11L.Height = 250
$Spreader11L.Font = $FontBold
$Spreader11L.Location = New-Object System.Drawing.Point(142,16)
$Form.Add_Load({$Equipment = "ARMG11L" ; CheckARMGIndex ; $Spreader11L.SelectedIndex = $Spreader11L.Items.IndexOf($ImportARMG[$Rowindex].Spreader)})
$Spreader11L.DataSource = $($Check11L)
$Spreader11L_SelectedIndexChanged=
{
    #Set current selected Spreader on Used NO in ARMG_Spreaders.csv
    $Equipment = "ARMG11L" ; CheckARMGIndex ; $Equipment = $($ImportARMG[$RowIndex].Spreader) ; CheckARMGSpreaderIndex ; $ImportARMGSpreaders[$Rowindex].Used = "NO" ; $ImportARMGSpreaders |Export-Csv "$CSVFile\ARMG_Spreaders.csv"
    #Set new selected spreader in ARMG.csv
    $Equipment = "ARMG11L" ; CheckARMGIndex ; $ImportARMG[$RowIndex].Spreader = $Spreader11L.text ;$ImportARMG |Export-Csv "$CSVFile\ARMG.csv"
    #Set new selected spreader on Used YES in ARMG_Spreaders.csv
    $Equipment = $($ImportARMG[$RowIndex].Spreader) ; CheckARMGSpreaderIndex ; $ImportARMGSpreaders[$Rowindex].Used = "YES" ; $ImportARMGSpreaders |Export-Csv "$CSVFile\ARMG_Spreaders.csv"
}
$Spreader11L.add_SelectedIndexChanged($Spreader11L_SelectedIndexChanged)


#### Functions ####
Function CheckARMGSpreaderIndex {
$Global:RowIndex = [array]::IndexOf($ImportARMGSpreaders.Name,$Equipment)
}

Function CheckARMGIndex {
$Global:RowIndex = [array]::IndexOf($ImportARMG.Name,$Equipment)
}

#### Variables ####
$ImportARMG = Import-CSV "$CSVFile\ARMG.csv"
$ImportARMGSpreaders = Import-CSV "$CSVFile\ARMG_Spreaders.csv"

#### Files ####
#ARMG_Spreaders.csv :
"Name","Used","Status"
"SPE001","YES","NI"
"SPE002","NO","WI"
"SPE003","NO","WI"
"SPE004","NO","WI"

#ARMG.csv
"Name","Status","BackColor","Spreader","Comment"
"ARMG11L","MPM","Red","SPE001","test"
"ARMG12L","WI","LightGreen","-",""
"ARMG13L","WI","LightGreen","-",""
"ARMG14L","WI","LightGreen","-",""
"ARMG15L","WI","LightGreen","-",""