VB Forum / General 2 / May 2004

Well, some remarks:
1.    Better look in a NG for Microsoft Office or Excel; this is Visual
Basic and not VBA
2.    The "added value" of what you want is not big, because to click in a
cell, you have to see the cell (and so you see the value of the cell); the
msgbox give you the same, but perhaps this is your start of a verry complex
application :). Second: you can't put directly any value in a cell by
clicking the cell to start your input; the msgbox will apear first.
3.    Try this: go in Excel to the menu View (I suppose that's the name: 3th
menu), then TaskManager (or someting like that) and check Visual Basic.
   Go to VB-editor and put this code in the Worksheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   MsgBox Target.Value, vbOKOnly
End Sub