I'm not exactly sure what you're asking, but....



You can remove highlighting  using the following line:



Selection.Interior.ColorIndex = xlNone

what I was looking for definately is a way of removing
selection highlighting, but I want to put this in an event. Like... in
access for example, there is a before update and and after update
event. I'm looking for something similar for changing the selection  so
I can remove highlighting  in the current  selection... then the
selection changes... then I can highlight the new current selection.

Have you looked in Excel help?

BeforeUpdate Event

Occurs before data in a control is changed.

Syntax

Private Sub object_BeforeUpdate( ByVal Cancel As MSForms.ReturnBoolean)

The BeforeUpdate event  syntax has these parts:

Part Description

object Required. A valid object.

Cancel Required. Event status. False indicates that the control should
handle the event (default). True cancels the update and indicates the
application should handle the event.

Remarks

The BeforeUpdate event occurs regardless of whether the control is bound
(that is, when the RowSource property specifies a data source for the
control). This event occurs before the AfterUpdate and Exit events  for
the control (and before the Enter event for the next control that
receives focus).

If you set the Cancel argument to True, the focus remains on the control
and neither the AfterUpdate event nor the Exit event occurs.

That's for a control on a form or sheet
rather than a selection  on a sheet.... but it *is* what I'm looking
for! I've been trawling the net as well but I thought someone here may
know.

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