Put a value of a cell in text box

P

Pasmatos

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.
 
D

Dave Peterson

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.
 
R

Ron Coderre

Try this:

Click on the Text Box to select it.
In the formula bar, enter the reference to the cell on the other worksheet
Example: =Sheet2!A1

Press the [Enter] key

Does that help?

***********
Regards,
Ron
 
P

Pasmatos

thanks for your help, that works.
Now if i have to put a reference name.
Exemple:

the table l1:g3 i have named tab1

how can i put this info in the text box ??

Thanks, i appreciate your help.
 
R

Ron Coderre

If I understand correctly, you want to display the tab1 range (I1:g3) on
another sheet. Try this:

Select the tab1 range
Hold down the [Shift] key and select Edit>Copy Picture
(Choose a display mode)
Release the [Shift] key
Select the destination worksheet
Edit>Paste
Next, with the image still selected, enter this in the formula bar:
=tab1
The image will now be linked to the tab1 range and display any changes to
that range in the image.

Now, experiment with the settings. For example, the pasted image will be
transparent, but if you set a fill color of white....you won't see the grid
lines behind the image.

Does that help?

***********
Regards,
Ron
 
Top