| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to strip figures from cells text strings | Excel Discussion (Misc queries) | |||
| Text Box Formula | New Users to Excel | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
| Conditional Formating when result is text | Excel Worksheet Functions | |||
| ANY FORMULA FOR CHECK =ISBOLD(A1) | Excel Worksheet Functions | |||
Linear Mode
