Formatting a substring within a cell only

[adim654]

Hi all,
The task I have requires repeatedly formatting specific words within cells, rather than the whole cell's text. I thought i'd try to write a macro to automate this, but can't seem to find anything about how to format only specific substrings in a cell. I was hoping to have the macro work something like this: select the word you want to format, run the code and it would apply the formatting to that word.

Does anyone know what the method would be for achieving this? I would think that there would be something similar to "CurrentSelection", which would be the most straightforward way to go about this.
Thanks in advance,
Alex

 

[KeepTrying]

I do not believe you can do that... when you select text within a cell, Excel is put into Edit Mode... as far as I know, nothing else can be done in Excel or VBA until Edit Mode is exited (which would mean the text would no longer be selected).

I'm also not aware of a solution for that.

Regards,

 

[adim654]

If you mean use the highlighted text to process all the cells in the Column, I do not believe you can do that... when you select text within a cell, Excel is put into Edit Mode... as far as I know, nothing else can be done in Excel or VBA until Edit Mode is exited (which would mean the text would no longer be selected).

Ah that's what I was looking for - I didn't know this is how Excel operated with Edit mode, as frustrating as that is, it makes sense. Thank you

 

[István Hirsch]

The task I have requires repeatedly formatting specific words within cells, rather than the whole cell's text. I thought i'd try to write a macro to automate this, but can't seem to find anything about how to format only specific substrings in a cell. I was hoping to have the macro work something like this: select the word you want to format, run the code and it would apply the formatting to that word.

This is exactly what „excelfindandformat” macro does, see more:

www.youtube.com/user/valfor221