Technical forums » Office applications »
Word macro: how to apply highlight to *all* selected text
Thread poster: Samuel Murray
Samuel Murray
Samuel Murray  Identity Verified
Netherlands
Local time: 07:10
Member (2006)
English to Afrikaans
+ ...
Dec 24, 2019

Hello everyone

I have a table in which I want to highlight certain cells. I'm using Ctrl+select to select the cells that I want to be highlighted. If I select cells and then use the normal "Highlight" button or function, it highlights all selected cells. But if I use the following macro, it highlights only the cells that I have selected last:

Sub highlight_with_shortcut()
Selection.Range.HighlightColorIndex = wdPink
End Sub

Just to be clear, ... See more
Hello everyone

I have a table in which I want to highlight certain cells. I'm using Ctrl+select to select the cells that I want to be highlighted. If I select cells and then use the normal "Highlight" button or function, it highlights all selected cells. But if I use the following macro, it highlights only the cells that I have selected last:

Sub highlight_with_shortcut()
Selection.Range.HighlightColorIndex = wdPink
End Sub

Just to be clear, the cells that I want to highlight are not next to each other, so I'm holding in Ctrl while selecting additional cells. The macro above then applies to only the cell(s) that I selected last, but I want the macro to apply to all selected cells.

How do I do that?
Thanks
Samuel ▲ Collapse
 
Hans Lenting
Hans Lenting
Netherlands
Member (2006)
German to Dutch
Neem er een loopje mee? Dec 24, 2019

Perhaps you have to insert a loop: for each cell in the range?
 
Rolf Keller
Rolf Keller
Germany
Local time: 07:10
English to German
Just a simple Loop Dec 24, 2019

Option Explicit

Sub highlight_with_shortcut()

Dim singleCell As Cell
Dim allSelectedCells As Cells

Set allSelectedCells = Selection.Cells

For Each singleCell In allSelectedCells
singleCell.Range.HighlightColorIndex = wdPink
Next singleCell

End Sub
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Word macro: how to apply highlight to *all* selected text






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »