How to change the COMMENT text color in VBA Code?
Open VBE
Click on TOOLS - - -OPTIONS
Click on EDITOR FORMAT - - -
Select COMMENT TEXT in CODE COLORS box
Select the required color from FOREGROUND dialogue box