+ Reply to Thread
Results 1 to 5 of 5

For each checkboxes in userform question

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Austria
    MS-Off Ver
    Excel 2016
    Posts
    165

    For each checkboxes in userform question

    Hi everyone,

    I have a macro that looks if all 16 checkboxes are true or false. If they are true, then they copy data. It works but I think that there is a much faster and better way to do that. Here are the first three checkboxes:
    Please Login or Register  to view this content.
    There are 16 checkboxes named from cbA to CbP. The range where the data is copied is from sheets("Gefiltert") from column C to Column R.
    I tried some macros with a for each loop, but I didnīt get it to work.
    Can you help me please?

    Thanks a lot. Kind regards
    Roman

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: For each checkboxes in userform question

    Roman

    You could loop through the checkboxes like this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Austria
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: For each checkboxes in userform question

    Hi Norie,
    thanks a lot for the very fast answer. I tried it but I get a syntax error at this line

    Please Login or Register  to view this content.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: For each checkboxes in userform question

    Oops, forgot the 'Then'.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Austria
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: For each checkboxes in userform question

    Thanks Norie, works perfect!!!

+ 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. [SOLVED] Toggle between userform checkboxes for multiple pairs of checkboxes
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-25-2016, 06:31 AM
  2. VBA Userform: Warn user if all checkboxes on a userform are unticked.
    By MrMiyagi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2014, 12:08 AM
  3. Userform Checkboxes!
    By shredraldz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 10:35 AM
  4. [SOLVED] Checkboxes in userform VBA
    By lealea1982 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 05:31 AM
  5. 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
  6. Checkboxes in Userform
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2010, 04:13 PM
  7. Userform with Checkboxes
    By Greg B in forum Excel General
    Replies: 5
    Last Post: 11-27-2005, 05:35 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