Thank you both for those solutions. This has now progressed int
something slightly different and after trying to modify your solution
above to make this work, still having issues.

What the desired result has now become...
If the user has cell M3 selected, then change cell S8 to show the dat
in cell K57. If the user has cell M5 selected, change cell S8 to sho
the data in cell K58...and so on.

Here is what I have that is not working.

Sub FieldTip()
If ActiveCell.Value = ("M3") Then Range("S8").Value = ("K57")
Else: If ActiveCell.Value = ("M5") Then Range("S8").Value
("K58")
Else: Range("S8").Value = " "
End If
End Sub

I attemped to first change the existing sub however it seems tha
Private Sub Worksheet_SelectionChange(ByVal Target As Range) will no
allow If Then statements. Might have been an error on my part whe
attempting to code however. Any help would be greatly appreciated.

~RBHick

--
Message posted from http://www.ExcelForum.com