Previous Topic Next Topic

Bold Text

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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 27, 2014 at 10:47 AM
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
0