+ Reply to Thread
Results 1 to 7 of 7

How to add tick boxes

  1. #1
    Registered User
    Join Date
    07-26-2008
    Location
    NW
    Posts
    11

    How to add tick boxes

    This is just my second post and I am quite new to Excel. I have already learnt a great deal from this site but I am ashamed to say that I don't understand a lot of the terminology so please bare with me with my 'basic' questions.

    I would like to know how to add tick boxes that can be checked / unchecked to alter a formula?

    Eg. If I have a list of figures and a total from those figures, would it be possible for me to turn certain lines in the list on and off to alter the total figure?

    Many thanks
    Daniel

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Link may help.

    http://articles.techrepublic.com.com...1-1041101.html

    I would suggest the following

    Select the next Col lets assume it's C. Format from Arial to Wingdings 2 then use a Upper case P for a tick then use a formula like

    =SUMIF(C:C,"P",B:B)
    Where Col C has the ticks (Capital P's) and Col B has values

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    07-26-2008
    Location
    NW
    Posts
    11
    That's great cheers.

    The spreadsheet example download doesn't appear to work though, I don't suppose you have a copy that you could send me do you?

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    I would avoid the tick boxes unless you only need a few but if you must then here a simple example

    VBA Noob
    Attached Files Attached Files

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Attached would be my option using a event macro. Double click a cell In Col C to add or remove the tick. See a

    Please Login or Register  to view this content.
    VBA Noob
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    07-26-2008
    Location
    NW
    Posts
    11
    Thanks very much for that.

    Would you avoid simply due to it being time consuming?

    To apply it to my spreadsheet could be very complicated.

  7. #7
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Time factor but mainly that it can slow down a spreadsheet

    VBA Noob

+ 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. Tick Boxes
    By djfatboyfats in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2008, 08:31 AM
  2. Hiding a row (Including tick boxes)
    By leelee23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2007, 05:11 AM
  3. Links to Tick Boxes
    By jamie.c in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-06-2007, 10:23 AM
  4. Can I Data Validate Tick boxes???
    By jamie.c in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2007, 07:22 AM
  5. Links to Tick boxes
    By jamie.c in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2007, 05:10 AM

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