Private Sub Cmd_Cancel_Click()
Unload Me
End Sub
Private Sub Cmd_Ok_Click()
If Cbo_Elect.Value <> "" Then BestandOpenen
End Sub
Private Sub UserForm_Initialize()
Cbo_Elect.List() = Blad1.Range("A2:A" & WorksheetFunction.CountA(Range("A:A"))).Value
Cbo_conn.List() = Blad2.Range("A2:A" & WorksheetFunction.CountA(Range("A:A"))).Value
Cbo_pin.List() = Blad3.Range("A2:A" & WorksheetFunction.CountA(Range("A:A"))).Value
Cbo_socket.List() = Blad4.Range("A2:A" & WorksheetFunction.CountA(Range("A:A"))).Value
End Sub
Private Sub Cmd_Ok2_Click()
If Cbo_pin.Value <> "" Then BestandOpenen
End Sub
Private Sub Cmd_Ok3_Click()
If Cbo_conn.Value <> "" Then BestandOpenen
End Sub
Private Sub Cmd_Ok4_Click()
If Cbo_socket.Value <> "" Then BestandOpenen
End Sub
Sub BestandOpenen()
Workbooks.Open "H:\TD Electrical Connector information\database connectors\datacards connectors\" & Range("A:A").Find(Cbo_Elect.Value, , xlValues, xlWhole).Offset(0, 1) & ".xlsx"
End Sub