Find and Replace

E

Ed

How do you use the "Find and Replace" block when everything is in text
blocks or word art?
 
D

DanielWalters6

I'm not sure you can...?

Could you not just use a blank worksheet and set the colour of all the cells
to WHITE, this way it wouldn't show the gridlines or anything? Then just put
the text into cells that work for you.

If you need more than one line of text per cell, you can always use the ALT
and ENTER to make a return within a cell.

Hope one of these helps,

Good luck with finding a proper answer!
 
E

Ed

Hi Dan,

Thanks for answering. I draw engineering drawings in excel and I use text
blocks and word art for text so that I can move things around easily in case
the text gets in the way of what I am drawing.
 
D

DanielWalters6

If you're creating engineering drawings then I suggest you use a more suited
program really.

I use OmniGraffle For Mac, which is brilliant, I am sure there is a Windows
Equivilent.

It allows you to export drawings to a million different formats, ie, jpg,
bmp, pdf, .doc, .ppt, not 100% sure on Excel, I'm away from my main computer
at the moment, so couldn't tell you.

But it's worth checking it out.

It's sooo simple my 9 yr old brother's using it for science diagrams and
homework.

Best of luck
 
E

Ed

Hi Dan,

I must use Excel because that is what is required at work. I draw the
sketches in Excel and then put them on a server so that others can look at
them and make changes. If there is a program that is compatible with Excel
that is easier to use, I would be interested. The program would have to be
capable of being pasted into Excel and also changes would have to be made
under Excel rules because my peers only have Excel on their computers.


Ed
 
D

DanielWalters6

I understand the situation you're in.

I do however still find it hard to understand what qualities of excel you
and your peers have seen that has made you adopt it as your format.

It's not brilliant for drawing lines, textboxes, word art, the only use I
can see is math functions built into it?
 
N

nhebb

How do you use the "Find and Replace" block
when everything is in text blocks or word art?
Click to expand...

Ed,

As far as I know, you would have to write a macro to do this. Here's a
quick example:

Sub ReplaceShapeText()

Dim shp As Shape
Dim newText As String

For Each shp In ActiveSheet.Shapes
If (shp.Type = msoAutoShape And Not shp.Connector) Or _
shp.Type = msoTextBox Then
newText = Replace(shp.TextFrame.Characters.Text, _
"Text", "New Text", , , vbTextCompare)
shp.TextFrame.Characters.Text = newText
ElseIf shp.Type = msoTextEffect Then
newText = Replace(shp.TextEffect.Text, _
"Text", "New Text", , , vbTextCompare)
shp.TextEffect.Text = newText
End If
Next

End Sub


Substitute the real text for "text" and "New Text", of course.
How do you increase the spacing between
diagonal lines on the Drawing Toolbar,
the Fill Effects drop down arrow, click
on "fill effects", then click on the
tab marked Pattern?
Click to expand...

As far as I know, there is no way to increase the spacing. You could
create your own bitmap with wider spacing and load it as a background
images in Fill Effects > Picture. But, the spacing would stretch and
vary by the size of the shape.
I do however still find it hard to understand
what qualities of excel you and your peers
have seen that has made you adopt it as your
format.
Click to expand...

Daniel,

A few years back I would have agreed with you, but I changed my mind
for a variey of reasons. One reason is the wide spread usage of Excel.
That means anyone with Excel can share, edit, and maintain the
drawings. The other main reason is the convergence of diagrams, data,
and documents. Also, the price of drawing tools is a factor -
especially as you multiply that across an organization.

I ended up creating an Excel add-in to automate flowcharting in Excel.
You'd be surprised at the number of people who use the built-in
drawing tools in Office. I know I was.

Nick Hebb
BreezeTree Software
http://www.breezetree.com
 
Top