How to extend a sting colour forward and backword until space is found ?

[jaimond]

some or a part of a substing has a color.
How to extend the color forward and backword until space is found to make it fully colored with the present colour ?
There are multiple rows, columns and sheets.

 

[Peter_SSs]

.. I can see no logic ...

Me either, but we are not the one posing the question and have no idea of the purpose or use of the result. So I have just tried to deal with the circumstances as given by the OP. So far at least, post #17 would indicate success.

 

[jaimond]

One.Two becomes One.Two

whereas

One.Two becomes One.Two [after "." it should check the space. If space is not found then this example appears problem]

I think here I need help then. Thanks Rick.

 

[Rick Rothstein]

One.Two becomes One.Two

whereas

One.Two becomes One.Two [after "." it should check the space. If space is not found then this example appears problem]

I think here I need help then. Thanks Rick.

Before a program can be written, we need clearly defined requirements. So far, you seem to be defining your requirements in pieces which causes any program that has been written to have to be revised, sometimes drastically so, in order to handle the "new" requirements. It would be real helpful if you could spell out in clear detail what should be colored and when. I am going to show you several text fragments with one or more characters colored within them... please show us how they should be colored. I noticed you were a little sloppy about doing this earlier, so I am going to ask you to check and then double-check the answers you give us (pay particular attention to whether the non-alphanumeric characters adjacent to the text with colored letters should be colored or not).

1) check and then double-check the answers

2) check and then double-check the answers

3) handle the "new" requirements

4) within them... please

5) I bought a new car (Toyota) today

6) pick a size (small/medium/large) for your order

7) pick a size (small/medium/large) for your order

8) pick a size (small/medium/large) for your order

9) an apostrophe 'quoted' word

I think that covers the bulk of the types of situations that need to be quoted around. Note that we will make "educated guess" about alternates above (for example, what you tell us to do with a dash in the middle of text is what we will do if that dash were a slash instead. Similarly, what you tell us about a word in parentheses is what we will do if the word is surrounded by square or curly brackets instead.

 

[Peter_SSs]

One.Two becomes One.Two

I am also unclear whether this statement is telling us what the answer should be, or what the previous code actually did when you tested it on your data?

 

[Rick Rothstein]

I am also unclear whether this statement is telling us what the answer should be, or what the previous code actually did when you tested it on your data?

@Peter,

I read the OP's comments within the square brackets of Message #22 as saying the coloring was correct if a space followed the dot, but not correct otherwise which I took to mean the first example with all the text colored was what he was after when there was no space after the dot.



@jaimond,

Make sure you look at Message #23 and answer all the questions I asked there.

 

[jaimond]

Help:

How to extend a sting color forward and backward until space is found?​

The VBA code can not turn .
Thankyou.Again = .Thankyou.Again
sss Thankyou.Again = .Thankyou.Again
to
Thankyou.Again = .Thankyou.Again
sss Thankyou.Again = .Thankyou.Again