text comparision

[Mark]

Hi,
How compare 2 text variable with different size font
(concern pagesetup)?
Operator "like" doesn't work.
Regards
Mark

 

[Chrissy]

I do not follow what you mean.

What are you trying to compare? The value stored in the variable?
A variable does not have a font property. If you mean two text
boxes on a form or two cells in a worksheet then just compare
one with the other like this

=IF(A1 = A2, "They are the same", "They are different")

or

IF TextBox1 = TextBox2 then
TextBox3 = "They are the same"
ELSE
TextBox3 = "They are different"
END IF

If that does not cover what you want can you explain it a bit more
please.

Chrissy.

 

[Mark]

My question regard compare text string in footer of
pagesetup.
I want compare only Text, not SizeText.
With operator "=" identical text not equal with another
size font.
Anyone knows how make comparison?

 

[Tom Ogilvy]

That would be true. If there are formatting charactes in the text string,
you would need to remove them to do the comparison.

You would loop through the string an parse out the command that are
delimited with &. I think you would have to write logic to include all
possibilities. This would be pretty complex.

Is it possible just to set the Footer or Header and not worry about what the
current setting is - or are you trying to append text?