Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Tick Cell

  1. #1
    Guest

    Default

    How do i add a cell where a person can tick or cross it?

    cheers for any help

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    United Kingdom
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A simple tick box can be added by going to:

    View/Toolbars/Forms

    On the Forms toolbar, select the tick box, go to the point on your spreadsheet where you want to insert it and drag&drop.

    Nobby

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put in worksheet code format column A as Marlett will put a check mark in column A, when you click in it, if there is something in the same row in another column. Click in the cell again and it will remove it, thanks to the board for help on this code.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim rng As Range, cell As Range
    If Selection.Cells.Count = 1 And _
    Not Intersect(Selection, Columns(1)) Is Nothing And _
    Not Intersect(Selection, ActiveSheet.UsedRange) Is Nothing Then
    With Selection
    If .Value = "a" Then
    .ClearContents
    Else: .Value = "a"
    End If
    End With
    End If
    End Sub

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what if u are using other column not A then what to enter in the code?

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yes marlet does this as said, but have look see over wing dings 1 and 2 and odd fonts change th eformatting.. myu fav is squashed frog, famouse in my building as its as cunning as a cunning plan

    it looks hust like a squashed frog

    ..

    ...

    ..
    ..
    ..


    NOT!

    but some good effect down there.

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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