tick box

  • Thread starter Thread starter mango7
  • Start date Start date
M

mango7

Hi,
I want to make a cekk in my wirksheet work like a tick box so that whe
it is double clicked a tick or "yes" appears to indicate that the job i
the previous column has been done
 
I do not think i understand what you are trying to do. You can have a
pick box that displays yes or no, and change it to yes when you have
finished the job. I use a spreadsheet that tracks audit actions, the
last column is "date action closed out". As soon as this cell is
populated with a valid date, every cell in that row turns green by the
use of conditional formatting.

Hope this helps.

Bobf
 
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Const WS_RANGE As String = "A1:A10"

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
.Value = "a"
.Font.Name = "Marlett"
.Offset(1, 0).Select
End With
End If

End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top