Ask Your Question

Insert a cell content in a text area or in a shape ?

asked 2016-08-22 20:13:01 +0100

Hello, I would like to insert the content of a cell in a text area or a shape. For instance put the value of C9 from sheet "formula" into a text area ? Thanks a lot Richard

edit retag flag offensive close merge delete


What kind is the target document? Writer, Draw, Impress? Do you want, that the target will update, when the value in the cell is changed? Do you work on Windows?

Regina gravatar imageRegina ( 2016-08-22 23:12:10 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-08-23 05:55:53 +0100

mark_t gravatar image

updated 2016-08-23 14:36:12 +0100

You could try using a List Box.

From the menu View, Toolbars, Form Controls to show the toolbar.

Select List Box and draw the outline on the worksheet. This should then show the list box wizard. Cancel the wizard.

Right click the box and select Control. This should show Properties: List Box.

Select the data tab and in Source Cell Range box you can give a cell reference to use for content of the List box.

Edit to add simple example, I forgot to attach last night. Untitled 12.ods

edit flag offensive delete link more


Thanks a lot mark, that works perfectly.


ricardo06 gravatar imagericardo06 ( 2016-08-24 15:32:23 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-22 20:13:01 +0100

Seen: 98 times

Last updated: Aug 23 '16