Clicking on a Cell

[kirkm]

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

 

[Mike H]

You could use the selection_change event

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


Mike

 

[kirkm]

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

Thanks Mike, That did it.

Why didn't I see that myself !!

Cheers - Kirk