Vlookup on ComboBox in Userform

[gdspeare]

Can someone guide me on why this is incorrect? As I'm sure you can tell this is simply putting the text in the label and not calculating a formula.

Private Sub ComboBox1_Change()

Label11 = "=VLookup(ComboBox1.Value, sla, 2, False)"

End Sub

Thanks,

 

[gdspeare]

Got it. Thanks. For those interested and don't know the answer it is:

Dim fn As Application
Dim lookupval As Variant

lookupval = Application.VLookup(ComboBox1.Value, Sheets("Data").Range("k:l"), 2, False)
Me.Label11.Caption = lookupval