View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sarah Lefevre Sarah Lefevre is offline
external usenet poster
 
Posts: 1
Default How do I put text and a cell reference in a text box?

Hello

I would like to put the following in a text box in an Excel worksheet
(version 2003):

The funding requirement for the Project is US$650m, which consists of
US$450m of senior debt, subordinated debt of US$100m and equity of US$100m.

I would also like the text box to source the numbers above from cells in the
the same Excel worksheet, so that the figures are automatically updated and I
don't have to go in and manually change the numbers every time there is an
update. I know how to put only a cell reference in the text box, but how do
I include the text too?

Any thoughts would be most welcome.

Sarah