+ Reply to Thread
Results 1 to 2 of 2

Assign Macro(s) to multiple checkboxes

  1. #1
    Registered User
    Join Date
    12-04-2008
    Location
    Vancouver
    Posts
    4

    Assign Macro(s) to multiple checkboxes

    Hello I am quite new to VBA coding in excel and have very limited knowledge of it. I use google to find something similar to what I need that somebody else has already done. I found a macro that works perfectly for me:

    http://www.ozgrid.com/forum/showthread.php?t=151192

    I have modified the second one to my specific needs. (9 columns with 300 checkboxes in each row with alternating color (15 & 16). Now that I have the 2700 checkboxes I need to assign a macro to them now. I have the macro's created already. There are 9 macros one for each of the 9 columns. So all checkboxes in row "G" need the same macro attached to them.

    If the macro on the attached website can be updated or a new code would work fine too. I have searched google for hours and cannot seem to figure this out. Any help is greatly appreciated and I apologize if I missed following board rules for this post.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: Assign Macro(s) to multiple checkboxes

    You have not explaind what check boxes you are using, but if you where using check boxes from the Forms control and placed it in the 1st cell with the assigned macro, then you could drag the cells down and the check boxes should copy down with the same assigned macro.

+ 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