View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim[_69_] Jim[_69_] is offline
external usenet poster
 
Posts: 4
Default Help with Vlookup a date

Please help
I am trying to use the WorksheetFunction.Vlookup to find a date on a
worksheet and then display a Msgbox containing the text in the adjacent
cell.
The date is intially entered in a textbox on a userform.
The Date Column (D) is formatted as date (dd/mm/yyyy)
However I get error 1004.


The code is as follows
MsgBox Application.WorksheetFunction.VLookup(Cdate(Textbo x2),
Worksheets(2).Range("D:E"), 2, False)


Regards & TIA