View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Put a value of a cell in text box

I put a textbox from the drawing toolbar on sheet2.

With that textbox selected, I put this in the formula bar:
=sheet1!a1

And when sheet1!a1 changes, so does the text in the textbox.

Pasmatos wrote:

Hi.
Please need help.

Could i put a value of a calculated cell in a text box. In another sheet of
the same workbook.

Thanks for your help.
Regards.


--

Dave Peterson