title: Enter special characters in Excel VBA
body: <p>How do I enter special characters in Excel VBA? For example if I want "●" (large interpunct) in some strings, they all appear as "?". I tried to substitute all "●" with <code>&amp;#9679;</code> in VBA but it didn't work, simply displayed <code>&amp;#9679;</code> in the string.</p>