In Cell Formating via VBA. Is it possible? 1

[petroffp]

Individual words within a text label can be bolded, underlined and otherwise formatted when entering a label from the keyboard. Can this kind of formatting be performed via VB?

 

[TonyJollans]

Hi petroffp,

Yes. Take a look at thread68-1075117 (in the Microsoft Office forum) - it's a long and winding thread but it does have recorded code to do this.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[petroffp]

Thanks...
You're right that was a rambling thread, but the conclusion was pretty simple...Turn on the macro-recorder and try it manually, and it will all become clear.
I keep forgetting how instructive the macro-recorder is.

 

[TonyJollans]

Yes .. it's a very useful learning tool. Glad you're sorted and hope the thread wasn't too much of a distraction - it was just fresh in my mind.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[