tick boxes

  1. H

    Adjust Sumproduct construction with Dropdowns

    Hi all Is there a way to construct an AND & OR sumproduct lookup that uses Tickboxes alongside a criteria range and also a toogle to state which of the list should be used as an OR or an AND criteria to adjust the outcome...
  2. S

    Cell values and conditional formatting

    Hello :) I am putting together a skills matrix that is to be used by other managers across the organization. There are three parts to this: 1) Identify a skill or competency required (sheet 1) 2) Score current staff skill level for each identified competency (sheet 2) 3) following, the...
  3. S

    Employee, Key Performance, Spreadsheet

    Hi Guys, I am trying to create a spreadsheet with a list or 30 or so KPIs we give to our casual staff. I am looking for a tick box system that I can tick the KPIs and it assigns say 5 points to tht employee. I then want to have the totals/percentage scored give a red/amber/green as to how...
  4. S

    How to automatically generate a user form with correctly labelled tickboxes to populate areas of a worksheet

    I have a large workbook which includes a number of macros already, one of which automatically loops through a number of different values to generate a consolidated report for each of those values. The available values in question are listed in cells C2:C101 of a sheet called 'Global Settings'...
  5. T

    only allow 1 tick box along a row

    Hi, I'd like 5 rows, with 4 tick boxes in each row. In each row, I'd like only 1 tick box that can be selected in each row. Currently I have 2 non-working versions 1: Only 1 box can be ticked in all the 5 rows !! 2: All of the tick boxes can be ticked !! Can you help out at all please? I an...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top