Temporarily change strings

[Un-Do Re-Do]

I want to select a number of cells, temporarily make changes as noted below, and show the changes in a format such as a picture in this case.
CHANGE 1: Change the dot character "." with a hashtag "#".
CHANGE 2: [Preamble: Assume all characters have a weighting of 1 except the hashtag character "#" which has a weighting of 0.5. So when counting the number of characters, 2 of "#" equal 1 of any other character.] .......... Then colour each character green if the count of that character is a whole number (for weighting of 1 and 0.5 respectively) or an even whole number (for weighting of 2 and 1 respectively). Otherwise colour red.

The code below is a work in progress and based on a sample from elsewhere. It does not incorporate Change 2.

* Note that when the code is run, the image width is only the size of the column and may not fit the total number of characters. Is there a way to make it fit the entire length of the data. Maybe a completely different method to display the data as opposed to the current method?


EXAMPLE

Cell data
a+b + ..1-jmq. - qw.erty
d-k .2np. 2k2m..j3
h+j .582. 2k2m...jk

Image required when macro is run
a+b + ##1-jmq# - qw#erty
d-k #2np# 2k2m##j3
h+j #582# 2k2m###jk

Please Login or Register  to view this content.

[karedog]

Maybe :

Please Login or Register  to view this content.

[Un-Do Re-Do]

@karedog
Thx, this works quite well.
But for some reason the more the macro is invoked, the slower it gets, after about 10 runs Excel freezes up.
Is this because the pictures are stored somewhere?

[karedog]

You are welcome.

No, there is only one picture affected (the "ZoomCell" picture), so it uses a very tiny system resources.
It seemed that you have another code running or other things that cause the slow down.
If you can't locate the cause by yourself, you need to upload your workbook, so I can find the cause.

[Un-Do Re-Do]

Please see attached.
Also can I change zoom level?

[karedog]

I tried the your attached file, it run very smooth on my PC, nothing is wrong.
I modify the code to avoid the event enabler and disabler, don't know if this could help on your PC.
I also add the Zoom feature to the code :

Please Login or Register  to view this content.

[Un-Do Re-Do]

Thx once more.

[karedog]

You are welcome, thanks for marking the thread as solved.

Regards