+ Reply to Thread
Results 1 to 3 of 3

Checkbox choices that run code on clicking command button

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    2

    Smile Checkbox choices that run code on clicking command button

    Hi Guys and Gals,

    I'm hoping to be able to create a userform containing multiple checkboxes (across multiple form pages). When some (or all) of these checkboxes are selected and a command button is pressed, I want to exceute some VBA that hides columns or rows based on the selections.

    I've been playing around with VBA for a few weeks now, so I'm happy making up the userform, hiding the rows or columns etc. I'm looking for a starting place. If anyone understands my babbling above, could you please help me out !

    Many Thanks

    Sharky

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Sharky,

    Why not place the code to hide the row or column in the Click event procedure? This way the row or column will be hidden as soon as the user clicks on it.

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    02-08-2007
    Posts
    2

    Smile

    Hi Leith,

    Thanks for the suggestion. I'd like to achieve this with a userform if possible. I already have a user for the click event (setting an autofilter).

    Perhaps I should divulge a little. The spreadsheet is quite large, over 140 columns. Clicking column names autofilters on "a" (used for ticks). I'd like the user to be able to select the ranges from the userform that fires on the workbook_open event, then they can filter on the selected columns if required

    Regards

    Sharky

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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