Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default text box in Excel 2007

Hi all,

Is it possible to add a formula in to a text box ( Ribbon: Insert Text
box)?

Kind regards,

Simon Minder
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default text box in Excel 2007

To link a cell to a Text Box object:

1. From the Drawing toolbar, click Text Box.
2. Select the Text Box, and press F2.
3. In the Formula Bar, create a link to a cell by typing = and then
selecting the cell.
The contents of the cell are displayed in the Text Box.

"Simon Minder" wrote:

Hi all,

Is it possible to add a formula in to a text box ( Ribbon: Insert Text
box)?

Kind regards,

Simon Minder

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text into charts (excel 2007) tom_h_c Excel Discussion (Misc queries) 1 October 15th 07 10:00 AM
Excel 2007: lock text box Vanquish Excel Discussion (Misc queries) 1 October 8th 07 07:46 PM
Excel 2007 Text Box Nick Excel Discussion (Misc queries) 3 May 10th 07 07:12 PM
text to speech in Excel 2007 Steve the Trumpet Setting up and Configuration of Excel 3 March 21st 07 09:30 PM
text to voice in EXCEL 2007 pcor New Users to Excel 2 December 29th 06 07:37 AM


All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"