I'm using an input box to gather a condition for a macro. I found out
that I could click in a cell containing the needed data as well as
typing in the input box. When I click on a cell the input box displays
the cell reference rather than the cell content. Is there a way to
have the input box display the content, for example 1/27/2011, rather
than the reference =$E$238, for example?