Thread: VBA: Look-Up Cell Date From User Input Box and return ALL matches
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mcasteel[_38_] Mcasteel[_38_] is offline
external usenet poster
  
Posts: 1
Default VBA: Look-Up Cell Date From User Input Box and return ALL matches

I'm looking for a look-up solution for a worksheet.

My worksheet column 68 contains dates. I need to figure out how t
code the following scenario:

The end user enters a date into an input box:
dtReportDate = (Date:=strReportDate).

I want to display ALL matching dates in another worksheet("To Do List"
to create a report. Im assuming I will need some kind of a Loo
Statement or For Each statement.

Can anyone help me out?

Thanks

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27714

Reply With QuoteReply With Quote