ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   StrikeThrough (https://www.excelbanter.com/excel-programming/315742-strikethrough.html)

Ben

StrikeThrough
 
Hi,

How to I check whether there is any striketrough on the text in one cell
with another text in another cell example:
column: a b

at at

where the two text are strikethrough. Note that the text must also be matched.

thank.

regards,
Ben



Mike Fogleman

StrikeThrough
 
If Range("A1").Value = Range("B1").Value And _
Range("A1:B1").Font.Strikethrough = True Then
MsgBox "OK"
End If

Mike F
"Ben" wrote in message
...
Hi,

How to I check whether there is any striketrough on the text in one cell
with another text in another cell example:
column: a b

at at

where the two text are strikethrough. Note that the text must also be

matched.

thank.

regards,
Ben






All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com