Results 1 to 3 of 3

Checkbox without text?

Threaded View

monkdelafunk Checkbox without text? 06-13-2008, 05:02 AM
Andy Pope Try. Sub... 06-13-2008, 05:06 AM
monkdelafunk Sorry, and thank you! 06-13-2008, 06:34 AM
  1. #1
    Registered User
    Join Date
    03-21-2008
    Posts
    52

    Checkbox without text?

    Hi,

    I am using the following macro to add multiple checkboxes to my spreadsheet:

    Sub MakeCheckbox()
    Dim myRng As Range
    
    Set myRng = Selection
    
    For Each ctrl In myRng.Cells
    ActiveSheet.CheckBoxes.Add(ctrl.Left, ctrl.Top, ctrl.Width, ctrl.Height).Select
    Next
    
    myRng.Select
    
    End Sub
    My problem is that the checkboxes have text next to them (checkbox 1 etc.) when I only want the box itself. Can anyone tell me how to do this? I'd also be interested in finding out if it is possible to 'anchor' the checkboxes to their respective cells.

    Thanks, Chris
    Last edited by Andy Pope; 06-13-2008 at 05:07 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1