Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link tick box to todays date (O97/O2K)

    Hi,
    I have a spreadsheet with tasks to do in a cell, and a tick box for completion placed on the cell next to it. Is it possible to link a cell to display the date completed in the next cell when the forms tick box has a tick in it?
    Thank you in advance
    Farside

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link tick box to todays date (O97/O2K)

    You could put some code like this in the checkbox's click event routine:

    <pre>Private Sub CheckBox1_Click()
    If CheckBox1.Value = True Then
    Worksheets("Sheet1").Range("C1").Value = Date
    Else
    Worksheets("Sheet1").Range("C1").ClearContents
    End If
    End Sub
    </pre>

    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link tick box to todays date (O97/O2K)

    Thanks LG, Brilliant,
    That's just what I needed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •