Hi Jennifer,

You also get that message if Ration is a string and you are looking for a
numeric.

Dim Ration As Variant: will cause a string to be returned from the Combo
box even though it has numerics.

If it is numerics in the combo then: Dim Ration As Long will fix the
problem

--
Regards,

OssieMac


"Stefi" wrote:

I cannot be sure, but VBA sends such an error message if Vlookup doesn't find
the value searched for. Check existence of "Ration" or use On Error!

Regards,
Stefi


€žJennifer€� ezt Ã*rta:

I am using this code to try and return a value in column d based from text in
the cboRation combobox. i am getting error

Unable to get Vlookup property of the WorksheetFunction class

Here is the code i am try to use
Private Sub GetSum()
Dim Ration As Variant
Dim Percent As String
Ration = cboRation.Value
Sheets("Rations").Activate
Percent = WorksheetFunction. _
VLookup(Ration, Range("PercentList"), 3, False)
me.lblPercent.valueu= Percent
End Sub

Thank you so much.
--
Thank you,

Jennifer