Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: USER FORM ISSUES: Clear data from various ranges using checkboxes and other issues.

  1. #11
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    13
    Code:
    Sub M_snb()
      For j = 13 To 24
        if Me("checkbox" & j) Then Sheets("Schedule").Range(MonthName((j - 4) Mod 12, True) & "_pay").ClearContents
      Next
    End Sub

  2. #12
    Member
    Join Date
    Jul 2013
    Posts
    40
    Rep Power
    0
    @ snb: bro thanks for the reply on that but that question has been answered although your solution seems shorter.

    my previous post however needs a solution...
    Last edited by MrBlackd; 10-13-2013 at 10:56 PM.

Similar Threads

  1. Sending Data From User Form To First Empty Row Of Sheets
    By paul_pearson in forum Excel Help
    Replies: 21
    Last Post: 08-14-2013, 11:04 PM
  2. Replies: 9
    Last Post: 12-04-2012, 09:45 PM
  3. Macro To Clear Certain Data Across Many Sheets
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 12-04-2012, 09:10 AM
  4. Macro to clear data based on color fill
    By Howardc in forum Excel Help
    Replies: 7
    Last Post: 12-03-2012, 09:25 AM
  5. Adding A Menu Bar To A User Form
    By Rasm in forum Excel Help
    Replies: 14
    Last Post: 05-05-2011, 04:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •