View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AJPendragon[_2_] AJPendragon[_2_] is offline
external usenet poster
 
Posts: 1
Default 2 Private Sub Worksheet_SelectionChange?

I already have 1 Private Sub Worksheet_SelectionChange(ByVal Target As Range)
which allows a combo box to appear on a validation list, but I want to add
another "SelectionChange" to allow a cell to always show the current cell a
cursor is in.

The macro falls over - ambiguous name - I presume you cannot have two
Private Sub Worksheet_SelectionChange(ByVal Target As Range) named the same
in 1 sheet.

Is there a way around this - renaming one does not seem to work.

Sorry but my knowledge of VBA is extremely limited.

Thanks


Andrew