Excel VBA Code Window Question

BobSullivan
3StarLounger
Posts: 235
Joined: 08 Jun 2010, 20:03
Location: Morgantown, PA

Excel VBA Code Window Question

Post by BobSullivan »

I know someone who is colorblind, so having red, green, blue and black text isn't helpful. Is there a way to have comments automatically show up in a different font? or having reserved words like If and Sub show in a different font? I know I can change colors, but that doesn't help him.
Cordially,

Bob Sullivan
Elverson, PA

User avatar
HansV
Administrator
Posts: 78475
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel VBA Code Window Question

Post by HansV »

No, all text in modules the Visual Basic Editor is displayed in a single font. One can change the font and font size, but it will be applied to ALL text in code modules.
So the best the user can do is select text and background colors that they can somehow distinguish (most colorblind people have problems distinguishing some colors, such as red and green, or blue and yellow, but not others)

S0503.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

BobSullivan
3StarLounger
Posts: 235
Joined: 08 Jun 2010, 20:03
Location: Morgantown, PA

Re: Excel VBA Code Window Question

Post by BobSullivan »

Thanks. I will let him know.
Cordially,

Bob Sullivan
Elverson, PA