Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text comparision
Hi,
How compare 2 text variable with different size font (concern pagesetup)? Operator "like" doesn't work. Regards Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text string comparision within excel | Excel Discussion (Misc queries) | |||
date comparision | Excel Discussion (Misc queries) | |||
dates comparision | New Users to Excel | |||
text comparision | Excel Discussion (Misc queries) | |||
Comparision formula | New Users to Excel |