CODEWITHSUNDEEP
vbaexcelcolors
Niko
Niko

Reputation: 29

Make my code color coded

I would like to color parts of my VBA Code. Is that possible? For example I would like to have colored cell references so that I can copy-paste code and find cell references faster in order to change them.

Thanks in advance! /Niko

Upvotes: 1

Views: 211

Answers (1)

SierraOscar
SierraOscar

Reputation: 17637

No, because the editor doesn't differentiate between a Range() method, a Cells() method or any other method. So if you change syntax highlighting for one you change it for all. The same with string arguments - it doesn't know that the string in Range("A1:C5") is a range argument - it just sees a string. So if you change the highlighting color for strings they will all change.

Upvotes: 1

Related Questions