Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Check Box Button (Excel 97)

    Hello,

    I need to create a button that a user can tick. It doesn't have to 'make' anything, it's just for visual purposes, to be put on a form that some people will have to fill in. I tried to use the Check Box from the Control Toolbox and the one from the Forms, but the problem with them is that they are very small (the actual place to be ticked). I need an object that can be enlarged to much bigger. Does anybody have an idea how to get such a resizable tick-box on my Excel sheet?

    Thanks,
    K.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Tick Box Button (Excel 97)

    You could play around with the ToggleButton from the Control toolbox.

    On the attached worksheet I have used a ToggleButton with a Labelfrom the Control Toolbar and a TextBox from the drawing toolbar. I set the font for the toggle button to Windings at 72 Point size. You can resize to suit.

    Then following code then shows a Check mark when the toggle button is True.

    Private Sub ToggleButton1_Click()
    With Me.ToggleButton1
    If .Value = True Then
    .Caption = Chr(252)
    Else
    .Caption = ""
    End If
    End With
    End Sub

    Andrew C
    Attached Files Attached Files

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

    Re: Tick Box Button (Excel 97)

    Hi Andrew,

    Thanks a lot for the attachment and the help. it is very good indeed, except for the actual character that I get as caption, when I click on it, the tick-mark changes to a flower kind of thing, see in the attachment, and I'm not sure I understand why...I tried it on another computer as well, and I got this other character there too.

    Thanks,
    K.
    Attached Files Attached Files

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Tick Box Button (Excel 97)

    When I open the file the caption starts out as a "flower" [it has a caption of chr(204)]

    But once I click on it, it goes from the check [chr(252)] to ""

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tick Box Button (Excel 97)

    Just to show you the final result of what I wanted to achieve. I've resized it, etc, and you can see the difference between this and the 'regular' check-boxes.
    Thanks to Andrew, I did it. For some reason it didn't work before, but it is fine now.
    Thanks again,
    K.
    Attached Images Attached Images

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Tick Box Button (Excel 97)

    It seems that you do not have Windings installed on your PC and it is being substituted with a different dingbat font.

    You need to find a suitable font on your system and change the font properties of the Toggle button to match. You may also need to replace Chr(252) with the appropriate value to use the relevant symbol from the font you select.

    Alternatively you could settle for an X symbol from any standard font.

    Andrew C

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Button (Excel 97)

    One way would be to set the font to all cells of that sheet relatively small and then use a zoom percentage larger than 100%.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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