Clicking on a Cell
 

You could use the selection_change event

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = Target.Text
End Sub


Mike

"kirkm" wrote:

Can clicking on a cell cause some text to appear in the status bar?
That's a single click (I'm already using double click).

Thanks - Kirk

Clicking on a Cell
 

On Wed, 23 Jul 2008 02:47:01 -0700, Mike H
wrote:

Thanks Mike, That did it.

Why didn't I see that myself !!

Cheers - Kirk

You could use the selection_change event

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = Target.Text
End Sub


Mike