greeting,
i'm looking for some pointers on how to go about searching and manipulating
text in the drawing layer in excel... we use the drawing layer for diagrams
and also use the spreadsheet layer... in the drawing layer, we insert text
into objects and text boxes. an example would be a flow chart, with text in
the objects of the flow chart diagram... we need to: 1- search and replace
strings in the drawing layer; 2- copy strings from the drawing layer into
the cells in a spreadsheet...

it seems to me that we could accomplish this by a macro or alternately to
use some kind of linking. for example, one can make a cell match the
contents of another cell just by using "=" then the cell reference. it
occurred to me that there may be a way to use one of the functions like
"text()" or something then give the object name as the argument. the object
name appears in the name box in the formula bar... if a select on of the
objects in the drawing layer, "rectangle 4" appears in the name box...

i've searched some of these web sites and found little on this topic...
preferably, if it requires a macro or script, i'd hope to find an existing
macro on the web. alternately i'd need some pointers on how get enough
information to write a script to accomplish these tasks...

if this is not the best place, can someone point me to another place for help?

i have excel version 11 on osx 10.4-

thanks for any advice anyone can offer-

If you use controls from the Forms toolbar, then select the textbox
or button (the cursor should not be in the caption area) and enter
a cell reference in the formula bar. It is that easy. Whatever text
is in the cell reference becomes the caption of the control.

It is even easier with a chart selected, enter ... ="jeffery" in the formula
bar and a textbox is automatically added to the chart with jeffery in it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"jeffery"
wrote in message
greeting,
i'm looking for some pointers on how to go about searching and manipulating
text in the drawing layer in excel... we use the drawing layer for diagrams
and also use the spreadsheet layer... in the drawing layer, we insert text
into objects and text boxes. an example would be a flow chart, with text in
the objects of the flow chart diagram... we need to: 1- search and replace
strings in the drawing layer; 2- copy strings from the drawing layer into
the cells in a spreadsheet...

it seems to me that we could accomplish this by a macro or alternately to
use some kind of linking. for example, one can make a cell match the
contents of another cell just by using "=" then the cell reference. it
occurred to me that there may be a way to use one of the functions like
"text()" or something then give the object name as the argument. the object
name appears in the name box in the formula bar... if a select on of the
objects in the drawing layer, "rectangle 4" appears in the name box...

i've searched some of these web sites and found little on this topic...
preferably, if it requires a macro or script, i'd hope to find an existing
macro on the web. alternately i'd need some pointers on how get enough
information to write a script to accomplish these tasks...

if this is not the best place, can someone point me to another place for help?

i have excel version 11 on osx 10.4-

thanks for any advice anyone can offer-

hi jim,

i haven't used the forms toolbar before... also, i'm not sure if you are
providing me with a way to get text from an existing text box in the drawing
layer into a blank cell in the spreadsheet layer or the other way around...

if i select the text box in the drawing layer (name box shows "rectangle
105"), the "control properties" button on the forms toolbar remains greyed
out... ??

thanks-


"Jim Cone" wrote:

If you use controls from the Forms toolbar, then select the textbox
or button (the cursor should not be in the caption area) and enter
a cell reference in the formula bar. It is that easy. Whatever text
is in the cell reference becomes the caption of the control.

It is even easier with a chart selected, enter ... ="jeffery" in the formula
bar and a textbox is automatically added to the chart with jeffery in it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"jeffery"
wrote in message
greeting,
i'm looking for some pointers on how to go about searching and manipulating
text in the drawing layer in excel... we use the drawing layer for diagrams
and also use the spreadsheet layer... in the drawing layer, we insert text
into objects and text boxes. an example would be a flow chart, with text in
the objects of the flow chart diagram... we need to: 1- search and replace
strings in the drawing layer; 2- copy strings from the drawing layer into
the cells in a spreadsheet...

it seems to me that we could accomplish this by a macro or alternately to
use some kind of linking. for example, one can make a cell match the
contents of another cell just by using "=" then the cell reference. it
occurred to me that there may be a way to use one of the functions like
"text()" or something then give the object name as the argument. the object
name appears in the name box in the formula bar... if a select on of the
objects in the drawing layer, "rectangle 4" appears in the name box...

i've searched some of these web sites and found little on this topic...
preferably, if it requires a macro or script, i'd hope to find an existing
macro on the web. alternately i'd need some pointers on how get enough
information to write a script to accomplish these tasks...

if this is not the best place, can someone point me to another place for help?

i have excel version 11 on osx 10.4-

thanks for any advice anyone can offer-

This code would go in the worksheet module...
(please be aware that a rectangle is not a textbox)

Sub AddCaptionToRectangle()
Me.Shapes("Rectangle 105").TextFrame.Characters.Text = "Sludge"
End Sub

Sub AddTextFromRectangleToWorksheet()
Me.Range("A1").Value = _
Me.Shapes("Rectangle 105").TextFrame.Characters.Text
End Sub
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html




"jeffery"
wrote in message
hi jim,
i haven't used the forms toolbar before... also, i'm not sure if you are
providing me with a way to get text from an existing text box in the drawing
layer into a blank cell in the spreadsheet layer or the other way around...

if i select the text box in the drawing layer (name box shows "rectangle
105"), the "control properties" button on the forms toolbar remains greyed
out... ??
thanks-




"Jim Cone" wrote:
If you use controls from the Forms toolbar, then select the textbox
or button (the cursor should not be in the caption area) and enter
a cell reference in the formula bar. It is that easy. Whatever text
is in the cell reference becomes the caption of the control.

It is even easier with a chart selected, enter ... ="jeffery" in the formula
bar and a textbox is automatically added to the chart with jeffery in it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"jeffery"
wrote in message
greeting,
i'm looking for some pointers on how to go about searching and manipulating
text in the drawing layer in excel... we use the drawing layer for diagrams
and also use the spreadsheet layer... in the drawing layer, we insert text
into objects and text boxes. an example would be a flow chart, with text in
the objects of the flow chart diagram... we need to: 1- search and replace
strings in the drawing layer; 2- copy strings from the drawing layer into
the cells in a spreadsheet...

it seems to me that we could accomplish this by a macro or alternately to
use some kind of linking. for example, one can make a cell match the
contents of another cell just by using "=" then the cell reference. it
occurred to me that there may be a way to use one of the functions like
"text()" or something then give the object name as the argument. the object
name appears in the name box in the formula bar... if a select on of the
objects in the drawing layer, "rectangle 4" appears in the name box...

i've searched some of these web sites and found little on this topic...
preferably, if it requires a macro or script, i'd hope to find an existing
macro on the web. alternately i'd need some pointers on how get enough
information to write a script to accomplish these tasks...

if this is not the best place, can someone point me to another place for help?

i have excel version 11 on osx 10.4-

thanks for any advice anyone can offer-