Is it possible to change the font color of comments in Vba code...??

[nirmal88]

---

Hi all
This is my first post and so I thought to start of with a curious question.....?

Just wanted to know if there is any inbuilt option in excel that would make comments in my Vba code appear in some other color, which by default is green.??

My best regards

 

[Rick Rothstein]

This is my first post and so I thought to start of with a curious question.....?

Just wanted to know if there is any inbuilt option in excel that would make comments in my Vba code appear in some other color, which by default is green.??

You can adjust the color, font and font size for comments as well as a few other part of your code. Go into the VB editor and click Tools/Options on its menu bar, then select the "Editor Format" tab on the dialog box that appears. For your direct question, select "Comment Text" from the list, click the Foreground dropdown arrow and change the Foreground color from the green that is currently selected to whatever color you want.

 

[nirmal88]

Thanks for the quick reply Mr. Ricky, I have read lots of your posts, I must say that I'm your fan on this forum.
That should help, regards

 

[moneyman4438]

hello, can the color be change for only specific comments

 

[Rick Rothstein]

The OP was asking about changing the color of comments in the VBA editor (those code statements that you put in your code with an apostrophe in front of it). If that is what you are referring to also, then the answer is "no"... the setting I referred to in my response applies to all comments for code comments within the VBA editor.

 

[hartless43]

You can adjust the color, font and font size for comments as well as a few other part of your code. Go into the VB editor and click Tools/Options on its menu bar, then select the "Editor Format" tab on the dialog box that appears. For your direct question, select "Comment Text" from the list, click the Foreground dropdown arrow and change the Foreground color from the green that is currently selected to whatever color you want.

Mr. Rick, we can add a few years to our age since you wrote this, but I have MSO 365 and I need to change my comment color and following your suggestions it ain't on my version of Excel.

 

[MARK858]

Mr. Rick, we can add a few years to our age since you wrote this, but I have MSO 365 and I need to change my comment color and following your suggestions it ain't on my version of Excel.

It's still there in my 365