Vlookup a date in a textbox within UserForm - VBA

[Cakz Primz]

Guys,

I need to lookup weekending date based on a textbox value in a userform
The code I have gave me a debug error message as follow "Unable to get the Vlookup properlty of the worksheet function class" When I disable "On Error Resume Next"

The lookup value, Arg1 is a textbox named = ProgressDate
Table is array on another sheet in the same file, Arg2, worksheet name = prima
Col_Index_Num, Arg3 = 2

Below is the code:

Private Sub ProgressDate_Change()
    'On Error Resume Next
    ProgressDay.Value = Format(ProgressDate.Value, "DDDD")
    Me.WeekEnding.Value = WorksheetFunction.VLookup(Me.ProgressDate.Value, Worksheets("prima").Range("GE3:GG5000"), 2, False)
    Me.WeekEnding.Value = Format(WeekEnding.Value, "dd-mmm-yyyy")
End Sub

Hope that someone in this forum could help me.
Thank you very much

prima - Indonesia

 

[bebo021999]

WorksheetFunction.VLookup(Me.ProgressDate.Value, Worksheets("prima").Range("GE3:GG5000"), 2, False)

Me.ProgressDate.Value should be Me.ProgressDay.Value

???

 

[Cakz Primz]

WorksheetFunction.VLookup(Me.ProgressDate.Value, Worksheets("prima").Range("GE3:GG5000"), 2, False)

Me.ProgressDate.Value should be Me.ProgressDay.Value

???

Dear bebo021999,

Me.ProgressDay is the weekday (Sunday, Monday, etc) based on Me.ProgressDate
I need to get the WeekEnding everytime the Me.ProgressDate is changing

Thank so much for your assistant.