Results 1 to 10 of 12

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

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 10-06-2013, 02:08 PM #1
    bakerman
    bakerman is offline
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    14
    Simple.
    Code:
     For j = 13 To 24
            If Me("Checkbox" & j) Then Sheets("Schedule").Range(Choose(j-12, "sep_pay", "oct_pay", "nov_pay", "dec_pay", _
                "jan_pay", "feb_pay", "mar_pay", "apr_pay", "may_pay", "jun_pay", "jul_pay", "aug_pay")).ClearContents
        Next
    Reply With Quote Reply With Quote
  2. 10-06-2013, 03:28 PM #2
    MrBlackd
    MrBlackd is offline
    Member
    Join Date
    Jul 2013
    Posts
    40
    Rep Power
    0
    I had figured it myself about the code. I asked sth different but nevermind it got clear by reading abt Choose.
    Thanks again for the help provided.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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. Clear Specific Rows Of Data On Multiple WorkSheets
    By Howardc in forum Excel Help
    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

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
  •  

Forum Rules