Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 95
Default text comparision

Hi,
How compare 2 text variable with different size font
(concern pagesetup)?
Operator "like" doesn't work.
Regards
Mark
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default text comparision

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" wrote in message ...
Hi,
How compare 2 text variable with different size font
(concern pagesetup)?
Operator "like" doesn't work.
Regards
Mark



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 95
Default text comparision

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?

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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default text comparision

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?

--
Regards,
Tom Ogilvy


"Mark" wrote in message
...
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?

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text string comparision within excel Fracky Excel Discussion (Misc queries) 1 September 10th 10 07:22 PM
date comparision User Excel Discussion (Misc queries) 0 April 3rd 10 11:31 AM
dates comparision surya and siva[_2_] New Users to Excel 1 July 1st 09 05:39 PM
text comparision Blah Excel Discussion (Misc queries) 5 July 19th 06 02:13 AM
Comparision formula manasi New Users to Excel 1 September 20th 05 07:06 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"