Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Fitting a checkbox into a cell

  1. #1
    Guest

    Default

    Hello,

    Please help. I created a checkbox (from the Forms toolbar) and set it to the smallest size it would allow me (0.24" x 0.33") and set the Properties to "Move but don't size with cells".

    I then positioned it above a cell. But, everytime I insert a row above the cell, the checkbox moves and gets resized.

    What I'm trying to make is a checklist by putting a checkbox in every row of my list. What's the best way to do this?

    Thanks.


  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I wouldn't use too many Controls as they can blow out file size for little return. Here is an alernative method that use the Marlett font and the letter "a" Just place it in the sheet in question, Right click on the sheet name tab, select "View Code" and paste in this

    Option Compare Text
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("B1:B20")) Is Nothing Then
    If Target = "a" Then
    Target = vbNullString
    End
    End If

    If Target = vbNullString Then
    Target.Font.Name = "Marlett"
    Target = "a"
    End If
    End If

    End Sub


    This particular code will toggle a tick on/off in the range B1:B20 simply by clicking in the cell.



  3. #3
    Guest

    Default

    Wow. You've been a really big help.
    Thanks, Dave Hawley.

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
  •