Results 1 to 2 of 2

userform checked and unchecked instances

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    58

    userform checked and unchecked instances

    Hi all, hopefully one you masterminds could help... I am using a "Sheet button" that when pressed a user form with 6 checkbox's and a button is called, when a box is checked and button pushed a named range is copied from a "range sheet" then pasted in the activesheet with an appended named range. When I click the "sheet button" a second time it remembers the previously selected checked boxes and when I uncheck one of the boxes that were previously checked it searches the active sheet for the appended named range and deletes it.

    Right now this only works if all the boxes are checked then all the boxes are unchecked. I get the error below if I try to selecting anything but everything. I have spent to many hours and I'm pretty sure I have hit a wall.

    This is the error I keep running into...
    Run-Time error '1004':
    Method 'Range' of object'_Global' failed

    Any help would be appreciated
    Last edited by arleutwyler; 02-17-2013 at 03:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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