Set formatting of cell when changes made

[Crawfy]

I have created a worksheet to track certain tasks. I am using the below VBA code to change all text before, and including, a semi-colon to bold as soon as i make a change to the cell, ie, when i enter text, the formatting is applied when i move onto another cell.
The code achieves the desired result, but does so by starting at the top of the row at cell F18 and applying the formatting to each cell till the end of the row. I want to make this more efficient and only apply the formatting to the cell i was working on whether i hit enter, tab or click away from the cell.
Attached is a cut down version of my spreadsheet.

Please Login or Register  to view this content.

Thank you in advance.

[mgs73]

I think this will do what you want:

Please Login or Register  to view this content.

Incidently, when you declare variables like this:

Please Login or Register  to view this content.

only I is being declared as an integer. In VBA you need to declare every variable explicitly, i.e. :

Please Login or Register  to view this content.

Also, as Excel has more than a millions rows, and Integer can count nowhere near that high it is generally best to use Long. Even for small numbers, there is no harm in using it.

[Crawfy]

Thank you mgs73,

That is certainly smaller and more efficient. However, all text in the cell is converted to bold, even if there isnt a semi-colon. I'd really like to have only text to the left, and including, the ";" converted to bold.
Any thoughts?

[mgs73]

How about this?

Please Login or Register  to view this content.

[Crawfy]

Perfect!!!