Thanks for the code, although I already know how to open a workbook, I some how worked it out myself and this is for any other fellow that come across this in the future. When items on the Listbox are clicked, it opens the associated workbook
Private sub ListBox1_Click()
Dim i As Integer
For i= 0 To ListBox1.ListCount -1
If ListBox1.Selected(i) Then
' Provided your ListBox1 has an item called Apple
' i.e I had ListBox1.AddItem("apple") previously.
If ListBox1.List(i) = "Apple" Then
If ListBox1.List(i) = "Google" Then
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...