+ Reply to Thread
Results 1 to 2 of 2

By clicking a tick box I would with like to add more ticks to additional cells?

  1. #1
    Registered User
    Join Date
    03-20-2017
    Location
    Solihull, UK
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    4

    By clicking a tick box I would with like to add more ticks to additional cells?

    I am new here, thank you for reading.

    I have an equipment builder sheet. In simple terms, column A is a description, column B is the price of that item & column c has a tick box. Currently, by selecting that tick box the cell in column B (the price) is then added as a value to all the other items that are also requested. In affect it adds all the columns B cells together that has a corresponding tick in column C and gives me a total at the bottom. This becomes the invoice amount for that piece of equipment. To add to this functionality, when i am selecting an option (using tick in column C) where this option demands other options to support its use I would like the sheet to automatically add a tick into the other required options. Is this possible and how is it achieved...? I would be so grateful for some help. Many thanks Matt

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,906

    Re: By clicking a tick box I would with like to add more ticks to additional cells?

    Like in your other post about the tick box, I think you should dig into macros to do this.
    No idea what you really have or want to achieve without sa sample, but my gut feeling is that writing a macro would be the best way to accomplish this
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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] Make cell tick just by clicking on it
    By Anarchus in forum Excel General
    Replies: 3
    Last Post: 12-11-2016, 09:02 PM
  2. [SOLVED] Modfication of Existing Code for additional additional cells
    By thilag in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2016, 03:00 AM
  3. Excel 2007 : Tick off a box after user ticks off tasks
    By pandaboom in forum Excel General
    Replies: 9
    Last Post: 12-20-2011, 04:06 PM
  4. Clicking on a cell to get additional details
    By excelaspire0219 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2009, 10:10 AM
  5. [SOLVED] [SOLVED] Creating a tick by clicking a cell
    By Justin Abel in forum Excel General
    Replies: 20
    Last Post: 04-24-2006, 04:30 PM
  6. [SOLVED] how do i create a tick by clicking on a cell
    By kirsty in forum Excel General
    Replies: 3
    Last Post: 06-08-2005, 11:05 AM
  7. Ticks/Crosses in cells?
    By melvin in forum Excel General
    Replies: 2
    Last Post: 01-28-2005, 06:21 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