Thread
:
Optimize Time In Filling Cells
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Optimize Time In Filling Cells
right click on sheet tabview codeinsert thissavedouble click on cell.
You probably want to restrict cells.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target = "" Then
Target.Value = 0
ElseIf Target = 0 Then
Target.Value = ""
End If
End Sub
--
Don Guillett
SalesAid Software
"rfs04" wrote in message
...
Hello all,
Does anybody know if it's possible to make excel putting a cross or a
circle or whatever in a cell only by clicking on it and if you click
again it disappears??
Maybe its science fiction?
Thanks in advance.
---
Message posted from
http://www.ExcelForum.com/
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]