Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling in blank cells with information from cells above it | Excel Discussion (Misc queries) | |||
filling cells | Excel Discussion (Misc queries) | |||
filling cells | Excel Discussion (Misc queries) | |||
filling in time in hours and minutes | Excel Discussion (Misc queries) | |||
Printing a workbook one row at a time filling in a form with the d | New Users to Excel |