Changing the font colour of particular sentences

[kittykatty]

Hi All

I'm hoping someone can help with this, as i am totally new at this VBA thing. I'm using Microsoft VISO to create Org Charts, and was hoping to find a simpler way of editting my charts before being able to post them out. I basically have boxes with position numbers and who is in them. If the person is Substantive, it will show "John Smith (S). If they are fixed term, it shows "John Smith (F). I want all of the names with the (S) to be red and all the names with (F) to be blue. is there some way to make this happen with some VBA code?

Please respond in simple terms, as i'm totally new at this. i appreciate your help, in advance

Thanks!

 

[hellind]

If strPerson = 'Substantive' Then
labelName.ForeColor = 255
End If


Basically declare a variable that stores the value depending on that the user clicks.

Then in VB code, use an IF ELSE statement to get what you want. Too hard to explain, it would help if you upload your code.