+ Reply to Thread
Results 1 to 2 of 2

Populate Userform with Checkboxes for each value in column A

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    47

    Populate Userform with Checkboxes for each value in column A

    Hello again,

    How can I make a userform populate with checkboxes for every cell in column A on sheet1 wich containing a text and the caption being the cellvalue?

    I'm assuming it must be done between in UserForm_Initialize()


    Private Sub UserForm_Initialize()

    checkboxes.add range(sheet2!A1:A200) 'no chxbxes for empty cells!'

    'Add checkbox starting from top left and going downwards and starting a new row when the botom of the userform is reached.'
    End Sub

    any help would be apriciated
    thx.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Populate Userform with Checkboxes for each value in column A

    a good place to star would be to peruse this code
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

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