View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Lars-Inge Tønnessen \(VJ# MVP\) Lars-Inge Tønnessen \(VJ# MVP\) is offline
external usenet poster
 
Posts: 5
Default VBA How do I set a value in a cell?

Yeaaahhh!!! :o)

This works like a dream.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
gogogo
End Sub

Public Sub gogogo()
Range("M5").Value = "Hello"
End Sub


Regards,
Lars-Inge