+ Reply to Thread
Results 1 to 4 of 4

assign macros to activeX Control checkbox

  1. #1
    Registered User
    Join Date
    09-06-2013
    Location
    santiago
    MS-Off Ver
    Excel 2007
    Posts
    15

    assign macros to activeX Control checkbox

    hey all,

    i have 17 activeX control checkboxes in one column. lets say if checkbox1 gets selected - 3 words appear in the next column (in different cells). if chcekbox2 gets selected, different 3 words apppear, below the previous words (in different cells again), and so on and so on... what i want to achieve is to have a list of words in one column, depending on the selection of checkboxes in the previous column.

    Any suggestions how i can do this??

    i am very very new at this, please have some pacience

    many thanks

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: assign macros to activeX Control checkbox

    something like this?

    Please Login or Register  to view this content.
    replace one two three with whatever words you want
    replace C2 with whatever cell you want the word to show up in

    x17 times
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: assign macros to activeX Control checkbox

    A small modification that doesn't change the way the code works but streamlines the logic:

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    09-06-2013
    Location
    santiago
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: assign macros to activeX Control checkbox

    thank you very much, works perfectly. you are a hero

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Assigning Macros to Macro created ActiveX Control Box
    By sm9748 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-18-2013, 02:02 PM
  2. WorkBook or ActiveX Control - Macros
    By way2suresh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2013, 03:58 AM
  3. [SOLVED] ActiveX control checkbox to (un-)check all checkboxes
    By Stefan1983 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2012, 07:39 AM
  4. Using ActiveX CheckBox Control to make a cell change colour and clear values
    By drmit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2012, 04:18 AM
  5. [SOLVED] format an entire column to contain checkbox activex control
    By blunoob in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-19-2005, 10:15 AM

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