checked

  1. R

    VBA to populate asset, location, time in, time out. And update column in table

    Hello all, I know MS Access would be better for this but excel is what I have to work with. I am trying to create a macro that will allow me to scan the bar code serial number of an asset and log it in cell A2, then scan the location Out to B2, Check out, to C2, and Check in, to D2, Location...
  2. B

    Formula using Check Boxes

    So I have a few formula's that are based on checkboxes that I've set up I was wondering if it's possible to have a formula that will physically check other boxes to true. I'll write it out in terms of how I'm wanting it: IF A10 is true (checked) then A1:A8 should all be checked. Basically...
  3. S

    sumif maybe?

    Hello Could anyone tell me how I go about determining in Excel 2010 if a person named in Col A has any one of the Category Columns checked. I don't need to know if they've got more than one ie Mick has three checked. That's not important to what Im trying to achieve. I'm thinking its some kind...
  4. P

    If checkbox = true, current date but..

    Hi everyone. So I'm trying to do the following. I have a column with a Checkbox, where the options are true or false, simple. If the option is set to TRUE, I want it to register the date that the checkbox was checked. If it has not been checked, to count the days that have passed since the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top