Make selection from ListBox1 to load specific info

[ipbr21054]

Morning,

Im making a userform for which i would like some advice please.
I have attached 2 screenshots.

ComboBox1 would have the info from Table 28 "MODELS" listed, A2:A11 " i have done this"

Upon the selection made i wish for its relevant info to be then shown in ListBox1 below.

Example,
A user would select say PCX & in ListBox1 i would see the infro from F2:F7

Once i sort this stage i will then move on to loading an image

 

[ipbr21054]

I have applied this but the Table code is shown in Red

Can you advise what i should be writting please.

Private Sub ComboBox1_Change()
If Me.ComboBox1.Value = "AIR BLADE" Then
ListBox1 = Table 30

ElseIf Me.ComboBox1.Value = "CBR" Then
ListBox1 = Table 31

ElseIf Me.ComboBox1.Value = "FORZA" Then
ListBox1 = Table 32

ElseIf Me.ComboBox1.Value = "LEAD" Then
ListBox1 = Table 33

ElseIf Me.ComboBox1.Value = "PCX" Then
ListBox1 = Table 34

ElseIf Me.ComboBox1.Value = "SH" Then
ListBox1 = Table 35

ElseIf Me.ComboBox1.Value = "VARIO" Then
ListBox1 = Table 36

ElseIf Me.ComboBox1.Value = "VISION" Then
ListBox1 = Table 37

ElseIf Me.ComboBox1.Value = "WINNER" Then
ListBox1 = Table 38

ElseIf Me.ComboBox1.Value = "X-ADV" Then
ListBox1 = Table 39

End If
End Sub