Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicking on cell | Excel Discussion (Misc queries) | |||
Run a macro when clicking a cell. | Excel Worksheet Functions | |||
clicking all the way to another cell | Excel Worksheet Functions | |||
Colour by clicking cell | New Users to Excel | |||
Pop up a Form when Clicking a Cell | Excel Programming |