Results 1 to 10 of 12

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Member
    Join Date
    Jul 2013
    Posts
    40
    Rep Power
    0
    @snb

    Capture.PNG

    If you see the attached image you will probably understand better what I am trying to do.

    I want to click on one or more months to select the monthly data range and then press the button to actually delete them.
    So I modified your code by replacing ClearContents with Selcet, intending to leave clear contents for the command button.
    The problem is that if I click one month then the data for this month is selected, but when selecting a second month then there is no union of the ranges... instead the range associated to this month is selected and the other selection is lost. Any idea?


    @ bakerman: I think that this did that job as intended, sorry to have missed your reply before posting again...

    Thank you both!
    Last edited by MrBlackd; 10-06-2013 at 12:34 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
  •