+ Reply to Thread
Results 1 to 2 of 2

Filter scrambles my checkboxes

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    kitchener ontario
    MS-Off Ver
    Excel 2007
    Posts
    1

    Filter scrambles my checkboxes

    Hi all,

    I've a pretty basic spreadsheet, three text columns, two with checkboxes, then another text. Trouble is, when I apply a filter to one of the text columns, my checkboxes don't line up with the same entries. they go back when I put the filter to the original, but as I'm entering data while filtered, they don't stay with the right entry. They also seem to stack and disappear if I sort to only show some entries.

    I've checked the forums and made sure "move but don't size with cells" is checked. (Move and size with cells is greyed out for some reason)

    Thanks!

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Filter scrambles my checkboxes

    Quote Originally Posted by jamie_sangster View Post
    I've checked the forums and made sure "move but don't size with cells" is checked. (Move and size with cells is greyed out for some reason)
    My initial instinct was this. Is it greyed out and checked or greyed out and unchecked?

    Also, are the checkboxes smaller than the cell they are within? IE: Are all of the borders of the check box within a single cell?

    What type of checkbox are they, form control, activex, etc?

    Can you post an example or at least a screenshot to demonstrate the problem?
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter one column with multiple checkboxes
    By pjohnson05 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 12-15-2021, 03:19 PM
  2. [SOLVED] Filter Excel cells using UserForm CheckBoxes
    By Darkenergyz in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 09-09-2021, 04:08 PM
  3. [SOLVED] Multiple Checkboxes to filter
    By Ashley.Martin100208 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-17-2014, 10:33 AM
  4. [SOLVED] Filter multi data Using combobox and checkboxes
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2014, 01:35 AM
  5. Using checkboxes to filter a list
    By Pete1989 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-15-2014, 06:57 PM
  6. [SOLVED] Use Checkboxes to Filter a List
    By corrinrenee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2013, 08:23 PM
  7. macro works fine once than scrambles everything the second time
    By drocket in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2007, 04:49 PM

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