+ Reply to Thread
Results 1 to 4 of 4

Multi checkboxes

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    26

    Multi checkboxes

    If I have several checkboxes within a userform and each one does the same upon clicking, I can use the following code:

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

    My question is: how can I adapt this code if the checkboxes were NOT in a userform but simply on a worksheet?

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Multi checkboxes

    The same i would have thought, but the controls are shapes, and not MSForms.Checkboxes, they dont have any events for you to sink though.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    05-30-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Multi checkboxes

    Quote Originally Posted by nathansav View Post
    The same i would have thought, but the controls are shapes, and not MSForms.Checkboxes, they dont have any events for you to sink though.
    But changing from:

    Please Login or Register  to view this content.
    to:

    Please Login or Register  to view this content.
    does not even compile.

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Multi checkboxes

    Thats what i said, they dont have events.

+ 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. Help: multi function macro needed - copy row, reset checkboxes, erase cells.
    By Acubed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-29-2014, 09:37 AM
  2. [SOLVED] Filter multi data Using combobox and checkboxes
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2014, 01:35 AM
  3. Replies: 4
    Last Post: 04-28-2013, 12:47 AM
  4. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  5. Replies: 19
    Last Post: 10-05-2012, 01:03 PM

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