| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change cell data using a mouse click?
You're welcome.
Gord On Mon, 28 Jan 2013 09:11:47 +0000, princejim wrote: 'Gord Dibben[_2_ Wrote: ;1608920']Right-click on sheet tab and "View Code" to open sheet module. Copy/paste this code into that module. Private Sub Worksheet_BeforeDoubleClick(ByVal Target _ As Range, Cancel As Boolean) ActiveCell.Value = 1 Cancel = True End Sub Close and d-click on any cell with a zero. Gord On Fri, 25 Jan 2013 19:18:47 +0000, princejim wrote: - I have tables with lots of cells containing a zero, I would like to change cells at random to a 1 just by clicking on the cell, new user so any help would be much appriciated.- Thanks Gord, brill just what I wanted, that makes the job of data entry easy. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to click a cell with mouse and have a different tab appear | Excel Programming | |||
| How to change action of double-click left mouse button? | Excel Discussion (Misc queries) | |||
| VBA - Click mouse to change cursor to cross hair that spans the en | Excel Programming | |||
| Add cell value with mouse click | Excel Discussion (Misc queries) | |||
| get value of a cell with a mouse click | Excel Programming | |||
![Gord Dibben[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
