Hi,

I presume you are referring to a RefEdit control? If so, I believe the
answer is "no". By design (not very good design, or at least not very good
implementation) this control is intended to identify a range in the sheet
and not its contents. If you wanted to you could build a form with a
RefEdit control and a text box and then have the text box display the
contents of the cell identified in the RefEdit control by trapping the
appropriate event.

Regards,

Peter Beach

"MAS" wrote in message
...
Hi,

Could someone please clarify for me.

I have some code that brings up an InputBox at which point I click on the
appropriate cell, in this case a column of names, but rather than the name
appearing in the InputBox, I see the Cell reference i.e. $B$1.

I then click on OK and process the name in the code as I planned.

What I want to know is if there is a way to get the contents of the
selected
Cell to show in the InputBox rather than the cell ref ?

If there is I will bet its something really simple that I have missed, but
I
have conceded defeat ;-)

MAS