ticked

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...

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...

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...

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...

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...

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...

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

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...