Multi-coloured string

Hi, you have to reprocess every character and set the font and color per character everytime a change is made.
That is the only way you will be able to achieve that in a character string.

Seems like a lot of effort is being put in to use excel in the opposite way to how it is supposed to be used.

Can you post a few examples of strings and the way that you want them colored?

Your explanation is very bad but this is the general idea, tweak as you like

After reading post #6, now it is clear why I can't understand the logic for your post #1 example.

You write :

Originally Posted by Excel_&_Help

Please Login or Register  to view this content.

while it really should be :

Please Login or Register  to view this content.

I cannot put the code here (the Sucuri is complained about something like SQL injection, as always), so look the code inside the attachment.

Looks good just allow for more rows in column A and the poster can be happy

Don't worry, I have prepared some chocolate and candy in case the poster is not happy (though it's not halloween yet).

Thanks for marking the thread as solved.

Regards

@karedog
With the code at post #7.
I've extended it to include other fonts, but funny things start to happen such as:
- Excel freezes up, typically if selecting more than one cell.
- Extra characters show up on the screen, but when you click the Formula bar, the correct number of characters are there.
- I have added some private use characters in my fonts and these do not show up, an alternative character shows up.

EDIT: After some further testing, this seems to happen when the first character is not, for example Font 01.

Please Login or Register  to view this content.

Some questions.
- What is SQL injection? Is this a threat to my work? Why would another forum member complain about it? Which part of the code is SQL injection? If so, is there a solution without it.
- The cases for {1/6, 1/3, 1/2, 2/3, 5/6, 1} are represented in VBA by {0.167, 0.333, 0.5, 0.667, 0.833, 1}. Is this a source of the problem?

>>> Excel freezes up, typically if selecting more than one cell.
It shouldn't. If the code is worked for one cell, it should worked for other cells too, only with longer time to do the calculation and changes

>>> Extra characters show up on the screen, but when you click the Formula bar, the correct number of characters are there.
>>> I have added some private use characters in my fonts and these do not show up, an alternative character shows up.
I have no idea about this, as you see in the code, all the macro doing is to change the font color only, no statement for adding new characters at all. Maybe the culprit is your "self made" fonts is not worked very well with Excel.

You also must put all of the fonts being used in the select case statement, or the macro won't worked.

Please Login or Register  to view this content.

>>> What is SQL injection? Is this a threat to my work? Why would another forum member complain about it? Which part of the code is SQL injection? If so, is there a solution without it.
Read this article to get the picture : https://en.wikipedia.org/wiki/SQL_injection
The bad guys (a.k.a. crackers) are always trying to break the website they targeting, one of the technique is adding some texts to query that user send to the webserver, in hope that the webserver gives response that actually shouldn't given to a normal user (such as admin privilleges, some secret data, etc). It is the job of the owner of the website (or his team) to always protect their website and update/patch the security holes/bugs/other flaws. But instead of doing this by himself, he also can "hire" someone/some company that offering the service to do this. And ExcelForum choose Sucuri (https://sucuri.net/) for this. But now, it is found out that Sucuri is giving too many "false alarm". Some texts that user send back to the server (our posts) is treated as an attempt to break the server. Some basic word like Replace immediately followed by open bracket, html tags, or other things (too many of them) is treated like this. So of course thing like this make the forum members feel very annoyed. They definitely are not crackers, they only posting some text (formulas or macros or data), but Sucuri page is popped up with annoying message.

The solution : One of the simplest way is to put the troubled texts (formulas/macros/data) inside a file (could be a text file, zip file, Excel file) and let the other forum members download this file and read the file, instead reading directly on the webpage. Sucuri will not check the file, it only checks the texts.

>>> The cases for {1/6, 1/3, 1/2, 2/3, 5/6, 1} are represented in VBA by {0.167, 0.333, 0.5, 0.667, 0.833, 1}. Is this a source of the problem?
No, because the previous statement is :

Please Login or Register  to view this content.

The reason I do this is because you want to continously add the floating point numbers, and after sometime, Excel will loose the digit of precession.
Take a look at this code :

Please Login or Register  to view this content.

If you run this code and examine the immediate window, you will notice that the last three numbers are :
1666.33333333353
1666.5000000002
1666.66666666687
You see, they supposed to be (but are not) :
1666.33333333333
1666.5
1666.66666666667
So, to avoid the problem like this, I choose to use the "Select Case Round(tot, 3)" method.