Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter value in cell by selecting cell.
When I move the mouse cursor over a cell and click to select the cell I would
like for an "X" to be placed in the cell without entering the "X" with a keyboard stroke. How do I accomplish this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter value in cell by selecting cell.
How about using doubleclicking and rightclicking:
Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ Cancel As Boolean) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("A:A")) Is Nothing Then Exit Sub Cancel = True 'stop editing in cell Target.Value = "X" End Sub Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _ Cancel As Boolean) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("A:A")) Is Nothing Then Exit Sub Cancel = True 'stop pop up from showing Target.Value = "" End Sub I used any cell in Column A. You can change that in both spots if you want. Doubleclicking will add the X. Rightclicking will empty the cell. Greyson wrote: When I move the mouse cursor over a cell and click to select the cell I would like for an "X" to be placed in the cell without entering the "X" with a keyboard stroke. How do I accomplish this? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter value in cell by selecting cell.
ps.
If you want to try, rightclick on the worksheet tab that should have this behavior. Select view code and paste that code into the code window. Greyson wrote: When I move the mouse cursor over a cell and click to select the cell I would like for an "X" to be placed in the cell without entering the "X" with a keyboard stroke. How do I accomplish this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
Need help with an embedded IF statement | Excel Worksheet Functions | |||
Enter 2 dates in same excel cell | Excel Discussion (Misc queries) | |||
Hitting Enter to Move Cursor to the Next Entry Cell | Excel Worksheet Functions | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) |