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.

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

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


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

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.

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

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 EditCopy Picture
(Choose a display mode)
Release the [Shift] key
Select the destination worksheet
EditPaste
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


"Pasmatos" wrote:

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.

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