Vlookup with combox and Datepicker VBA

[Excelnewbie001]

I need to borrow someone brain for some help please.

Scenario

I have Combox3 which value set via Rowsource on the property tab -It works! I am using a Datepicker to store data underneath the datepickers date starting in Row 4 going down for the day -it wont exceed 400 rows going down) So I want to check combobox3.value with vlookup against the stored datepickers data starting at row 4 going down in the column. My problem is how do I set a range on a datepicker as every day it will be in a new column. My main aim is to check if the combobox 3 value are in the column for that respective day.

Need help to do a Vlookup on Datepicker range but I dont know how to set the range. I get stuck here

ComboBox3.Value = VLookup.DTPicker3.Value.Range

    Sub check_match
    On Error GoTo ErrorHandler
    Dim Matchvalue As Integer
    MatchValue= Combobox3.Value


[COLOR=#ff0000]    If Application.WorksheetFunction.VLookup.Combobox3.Value , 1, False = "MatchValue" Then
        MsgBox "Number is in Database [/COLOR]"
    Else
        MsgBox "Number was not in the Database "
    End If
    Exit Sub
ErrorHandler:
    MsgBox "Number was not in the  Database "
End Sub

Thanks for any help

 

[Excelnewbie001]

Re: Vlookup with combox and Datepicker VBA help

Bump anyone used a datepicker using a vlookup ANYONE ?