Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Michael Cox   on Oct 01 In MS Office Category.

  
Question Answered By: Konrada Schmidt   on Oct 01

One way is to clear all of the same type of highlighting  from the
whole sheet everytime the selection  changes, just before you apply
your highlighting.
This code  illustrates this using a different method to highlight the
currently selected cell(s):

Private Sub Worksheet_SelectionChange(ByVal target  As Range)
Cells.Interior.ColorIndex = xlNone
Selection.EntireRow.Interior.ColorIndex = 15
Selection.EntireColumn.Interior.ColorIndex = 15
End Sub

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on E2000 Events Or get search suggestion and latest updates.


Tagged: