Find and Replace
 

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

Find and Replace
 

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!

--
Dan Walters


"Ed" wrote:

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

Find and Replace
 

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.
--
Ed


"DanielWalters6" wrote:

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!

--
Dan Walters


"Ed" wrote:

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

Find and Replace
 

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


--
Dan Walters


"Ed" wrote:

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.
--
Ed


"DanielWalters6" wrote:

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!

--
Dan Walters


"Ed" wrote:

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

Find and Replace
 

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


"DanielWalters6" wrote:

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


--
Dan Walters


"Ed" wrote:

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.
--
Ed


"DanielWalters6" wrote:

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!

--
Dan Walters


"Ed" wrote:

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

Find and Replace
 

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?


--
Dan Walters


"Ed" wrote:

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


"DanielWalters6" wrote:

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


--
Dan Walters


"Ed" wrote:

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.
--
Ed


"DanielWalters6" wrote:

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!

--
Dan Walters


"Ed" wrote:

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

Find and Replace
 

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

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?

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.

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