Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP with a date, from A1 = Now() | Excel Discussion (Misc queries) | |||
vlookup by date | Excel Worksheet Functions | |||
vlookup using date | Excel Discussion (Misc queries) | |||
Vlookup and Date | Excel Worksheet Functions | |||
Date VLookup | Excel Worksheet Functions |