ticked

  1. N

    Excel2016. Return several criteria for an article as text

    Hello, I have a list with articles which have technical criteria. I would now like to have the criteria returned as text but the complicated bit for me is how I can show the different temperatures... I tried if functions but it didn't really work. Would anybody know how best to solve this? My...
  2. M

    Multiple IF (Nested If Statement) returning false as value when false

    Good Morning, I'm new to the forum and trying to brush up on my Excel skills to improve efficiencies with my daily work tasks. I'm just starting to learn about multiple if / if and statements to save me creating extra columns etc I'm using a tick box to give a true/false value, if the box...
  3. A

    Use a drop down cell to copy date from one cell to another

    Hi I don't seem to be able to get this to work. I have created a cell with a dropdown menu in it. The dropdown cell is L9. If the L9 cell says "Cash" then I want the value in cell J9 to be copied to cell M9, otherwise I want the cell M9 to stay empty. I have added this formula into cell M9...
  4. S

    Looking up a multiple choice answer?

    Hi. On sheet2, I have a load of questions & answers from a survey. Row 90, Columns D and E contain Yes and No respectively as the answer options, with a tickbox in each cell, one of which is ticked for each question. On sheet1, I want to enter in cell b2 a formula which will return the result...
  5. S

    Check boxes linking different formulas to one Cell

    Hi Guys, I'm running an accounting spreadsheet and what I want to do is have one cell lets call it A1 display a different result based on a different formula depending on what Checkbox is ticked For example if "Reinvest" checkbox is ticked it does sum(C1+B1) if "Take" checkbox is checked it...
  6. A

    How to know if "disable all macros with notification" is ticked?

    Excel friends, I found the thread below to know if "Trust Access Visual Basic Project" is ticked. It works perfectly, but in addition to it, I also need to know if "disable all macros with notification" is ticked. The ideal will be to identify which one of the four is ticked. Is there any way...
  7. L

    Silly Error Question (sub not defined)

    Hello, Been getting sub or function not defined when using: Outlook.Application IsAppRunning Does anyone have ideas I'm pulling my hair out, chances are it's something in tools/references but I'm confident I have what's required ticked... Luke
  8. rhino4eva

    Userforms

    I am attempting to teach myself how to do userforms I can draw them and get the code behind them but I am struggling to pull everything together . If I describe what I need could someone please help out I have 7 tick boxes on a USER FROM lined up named CEA,HAV,ENT,MENIGO,PHM,PCP,RNASEp and one...

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
Back
Top