Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Optimize Time In Filling Cells
rfs04 wrote:
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? If you'd settle for a right-click you could try something like: ''' Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) Select Case Target.Formula Case "": Target.Formula = "X" Case "X": Target.Formula = "O" Case Else: Target.Formula = "" End Select Cancel = True End Sub ''' Though you might want to check the range you are in. For instance add: If Target.Row 3 Or Target.Column 3 Then Exit Sub before the Select Case if you're playing noughts & crosses (tic-tac-toe) -- Steve Garman |
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 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 | |||
Optimize Time In Filling Cells | Excel Programming |