[Excel] Turning Cells into Checkboxes-VBForums
Results 1 to 5 of 5

Thread: [Excel] Turning Cells into Checkboxes

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2011
    Posts
    2

    [Excel] Turning Cells into Checkboxes

    I'm having a big problem with Excel. Every month I send out spreadsheets to other departments of thousands of charges for approval. As they repeatedly mangle the spreadsheet before sending it back to me, I would like to send it password protected. I would like to add a column of checkboxes (one for each of the thousands of cells) that the department can click on to signify the individual line is approved. I cannot figure out how to do this, as the checkbox that Excel has offered up in the Developer tab is ungainly to use. Is there a way to turn an entire column into check boxes that can also be filtered for?

  2. #2
    Super Moderator Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    11,928

    Re: [Excel] Turning Cells into Checkboxes

    Welcome to the forums mandy3gt

    Use Data Validation and change the Font of that Column to "Wingdings 2"

    Now if you type "P" in that column it will show as a Tick.

    See Sample Attached

    Sid
    Attached Files Attached Files
    The poster formerly known as koolsid
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved

    Microsoft MVP: 2011 - Till Date IMP Links : Acceptable Use Policy, FAQ

    MyGear:
    Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011

  3. #3

    Thread Starter
    New Member
    Join Date
    Jan 2011
    Posts
    2

    Smile Re: [Excel] Turning Cells into Checkboxes

    Thanks for your help. That's a solution that I considered, the only problem is if I give them an inch with the spreadsheet, they'll take a mile. Soon people would start typing entire epics into that space I leave unprotected if they determine that it's just a regular text box.

  4. #4
    Super Moderator Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    11,928

    Re: [Excel] Turning Cells into Checkboxes

    In data validation, you can also restrict them from typing anything else

    Check the link in my signature on Data Validation

    Sid
    The poster formerly known as koolsid
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved

    Microsoft MVP: 2011 - Till Date IMP Links : Acceptable Use Policy, FAQ

    MyGear:
    Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011

  5. #5
    Super Moderator RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,164

    Re: [Excel] Turning Cells into Checkboxes

    You could simply have them place a 1 or 0 in the last column to signify its an approved row or not.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Star Wars Gangsta Rap Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 300 GB HDs, 2 GBs DDR2 667 MHz RAM, 2 Viewsonic 24" LCDs, Windows 7 SP-1/Windows 8.1, Office 2010, VS 2013

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.