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

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
>

On Wed, 23 Jul 2008 02:47:01 -0700, Mike H
<(E-Mail Removed)> 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