Hi

I have a spreadsheet with some text in it, and I do not want to
increase the cell size to display it. Is there a way I can write a
macro to display the cell value on an input box (like in data
validation), when there is focus on the cell?

I have been able to do this for only one cell, but it has a range
reference to it - how do i refer to the cells own value, to display it
on the input box?


Thanks