I have a macro that uses an input box to ask the user for a date (to lookup).
The date is stored as mybegdate. I am using a lookup to find "mybegdate" in
the appropriate table. But it is not working. My guess is it doesn't
recognize mybegdate.
Is there a way to have mybegdate appear in a cell - that way I would know
that the value exists somewhere. Or maybe I am just referring to it
incorrectly in the lookup. This is my attempt to address my FY posting of a
couple of days ago.

My macros currently reads:
Range("z1").Select
mybegdate = InputBox("What date (MM/DD/YYY) will mark the beginning of the
review period?")
ActiveCell.FormulaR1C1 = "=mybegdate"
Range("z2").Select
ActiveCell.FormulaR1C1 = _
"=LOOKUP(" & mybegdate & ",'[Trending
Source.xls]Stats'!R14C1:R27C1,'[Trending Source.xls]Stats'!R14C2:R27C2)"

TIA