|
How to check for a bold text formating through (in) a formula?
Hello experts!
How to check for a bold text formatting through (in) a formula? |
How to check for a bold text formating through (in) a formula?
A simple UDF will do it
Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function and use like =IF(ISBold(A1),...) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Dmitry Kopnichev" wrote in message ... Hello experts! How to check for a bold text formatting through (in) a formula? |
How to check for a bold text formating through (in) a formula?
Thanks Bob.
I opened Visual Basic Editor, clicked menu View, Code, and pasted the Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function Then clicked save. The formula =ISBold(A1) gives #NAME? , where A1 is bold text. What is wrong? "Bob Phillips" сообщил/сообщила в новостях следующее: ... A simple UDF will do it Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function and use like =IF(ISBold(A1),...) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Dmitry Kopnichev" wrote in message ... Hello experts! How to check for a bold text formatting through (in) a formula? |
How to check for a bold text formating through (in) a formula?
Thanks. I know now.
"Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Thanks Bob. I opened Visual Basic Editor, clicked menu View, Code, and pasted the Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function Then clicked save. The formula =ISBold(A1) gives #NAME? , where A1 is bold text. What is wrong? "Bob Phillips" сообщил/сообщила в новостях следующее: ... A simple UDF will do it Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function and use like =IF(ISBold(A1),...) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Dmitry Kopnichev" wrote in message ... Hello experts! How to check for a bold text formatting through (in) a formula? |
How to check for a bold text formating through (in) a formula?
Glad you got your answer.
Please Share - what was the problem before you solved the it? "Dmitry Kopnichev" wrote in message ... Thanks. I know now. "Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Thanks Bob. I opened Visual Basic Editor, clicked menu View, Code, and pasted the Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function Then clicked save. The formula =ISBold(A1) gives #NAME? , where A1 is bold text. What is wrong? "Bob Phillips" сообщил/сообщила в новостях следующее: ... A simple UDF will do it Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function and use like =IF(ISBold(A1),...) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Dmitry Kopnichev" wrote in message ... Hello experts! How to check for a bold text formatting through (in) a formula? |
How to check for a bold text formating through (in) a formula?
One typical problem with UDFs is that they weren't placed in a General
module--sometimes, they're placed under a worksheet or under ThisWorkbook and then the Name error is returned. JMay wrote: Glad you got your answer. Please Share - what was the problem before you solved the it? "Dmitry Kopnichev" wrote in message ... Thanks. I know now. "Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Thanks Bob. I opened Visual Basic Editor, clicked menu View, Code, and pasted the Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function Then clicked save. The formula =ISBold(A1) gives #NAME? , where A1 is bold text. What is wrong? "Bob Phillips" сообщил/сообщила в новостях следующее: ... A simple UDF will do it Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function and use like =IF(ISBold(A1),...) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Dmitry Kopnichev" wrote in message ... Hello experts! How to check for a bold text formatting through (in) a formula? -- Dave Peterson |
How to check for a bold text formating through (in) a formula?
Yes, Dave Peterson is right.
"Dave Peterson" ???????/???????? ? ???????? ?????????: ... One typical problem with UDFs is that they weren't placed in a General module--sometimes, they're placed under a worksheet or under ThisWorkbook and then the Name error is returned. JMay wrote: Glad you got your answer. Please Share - what was the problem before you solved the it? "Dmitry Kopnichev" wrote in message ... Thanks. I know now. "Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Thanks Bob. I opened Visual Basic Editor, clicked menu View, Code, and pasted the Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function Then clicked save. The formula =ISBold(A1) gives #NAME? , where A1 is bold text. What is wrong? "Bob Phillips" сообщил/сообщила в новостях следующее: ... A simple UDF will do it Function IsBold(rng As Range) As Boolean Application.Volatile IsBold = rng.Font.Bold End Function and use like =IF(ISBold(A1),...) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Dmitry Kopnichev" wrote in message ... Hello experts! How to check for a bold text formatting through (in) a formula? -- Dave Peterson |
| All times are GMT +1. The time now is 05:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com