Red Dot

I have a need, using VBA, to replace certain data in a column with a red dot. In my sample document if a field in column G contains "X", "D", "B", or "E" then it is replaced by a red dot. If it contains another character then the field is cleared. My major obstacle is my inability to replace the characters with a red dot. As always, any help is appreciated.


Thanks,

Met

One way

Please Login or Register  to view this content.

Hmm. When I run the code listed above it seems to clear all the contents in column G. Let me dig into this a bit deeper, I must be missing something.

Try this mod to jindon's code

Please Login or Register  to view this content.

Metrazal

try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Perfect. Thanks for the help. I appreciate it.

Did the change I suggested work?