Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlighted Text, Creating Macros (Office 2003)

    Can anyone help?

    I just have a quick question, is it possible to create a macro in Excel that highlights text? I have attempted to record a macro, type text, then highlight the text. Everything works as expected apart from the text not appearing highlighted.

    Many thanks
    Jack

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighted Text, Creating Macros (Office 2003)

    What exactly do you mean by highlighted text? If you mean the highlighting that occurs when you select some text within a cell, that is not possible in a macro.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighted Text, Creating Macros (Office 2003)

    Thanks as alwways Hans

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighted Text, Creating Macros (Office 2003)

    It is possible to change the font color of part of the text in a cell, though. For example, to make the 4 characters starting at the 3rd character blue:

    Range("A2").Characters(3, 4).Font.Colorindex = 5

  5. #5
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighted Text, Creating Macros (Office 2003)

    Hi Hans

    I have a user who is claiming that he can no longer create macros that highlight text in Excel. After testing this myself I was unable to highlight text via a macro and just needed to confirm this.

    I think there may be case of a user not really knowing what he is doing and claiming that applications are not running as expected. Who needs users !!!!

    Regards
    Jack

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighted Text, Creating Macros (Office 2003)

    Are you sure it's about Excel? Word has a "marker pen" feature that can be used to highlight text, Excel hasn't.

  7. #7
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighted Text, Creating Macros (Office 2003)

    Have now contacted the user and it is very much a case of "user error". He is playing with macros but does not have a clue about what he is doing. Now it's all making sense !!

    Thanks
    Jack

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighted Text, Creating Macros (Office 2003)

    OK, we'll leave it at that then... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •