Bold Text

Solved/Closed
Game Start Now Posts 138 Registration date Thursday 21 January 2010 Status Member Last seen 8 May 2019 - 26 May 2014 à 10:51
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 May 2014 à 10:47
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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
27 May 2014 à 10:47
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