Bold Text

Solved/Closed
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Posts
2849
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 27, 2022
-
Hello Sir,

I required the macro to bold some specific text in cell like:

Below mentioned formula is written in cell

="We are enclosing herewith a cross cheque bearing No. "&VLOOKUP(DATE(YEAR(AJ8),MONTH(AJ8)-1,1),'Yearly EOBI Payment 2014'!$B$6:$H$17,5,0)&" dated "&TEXT(VLOOKUP(DATE(YEAR(AJ8),MONTH(AJ8)-1,1),'Yearly EOBI Payment 2014'!$B$6:$H$17,6,0),"dd-mmm-yyyy")&" amounting"

I want the function macro to bold the specific text which I want to bold from the formula.

Like Function Formula Named As "TextBold"

=TextBold("We are enclosing herewith a cross cheque bearing No.") And
=TextBold(A1)

I want both condition works.

So I may bold the specific text in formula cell using function


Looking forward to your usual cooperation.

Regards,

Game Start Now

1 reply

Posts
2849
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 27, 2022
491
Hi GSN,

After reading some more on custom functions, I found out that your request is undoable.

I took this from the Microsoft site:
Custom functions are not allowed to do anything other than return a value to a formula in a worksheet or to an expression used in another VBA macro or function. For example, custom functions cannot resize windows, edit a formula in a cell, or change the font, color, or pattern options for the text in a cell.

Source: http://office.microsoft.com/en-us/excel-help/creating-custom-functions-HA001111701.aspx#BMstart

Best regards,
Trowa