Input box display

[Slim Slender]

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?

 

[GS]

Slim Slender presented the following explanation :

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?

This suggests you're using Excel's InputBox method rather than VBA's
InputBox function. In this case, selecting cells is possible because
the control is actually a refedit and so will return the selection
address. That said, to get the cell contents you can use the address in
the normal fashion:

sMyVal = Application.InputBox... '//get cell reference
sMyVal = Range(sMyVal).Value '//replace with contents

HTH

 

[GS]

I should have said the var sMyVal should be declared as Variant type.