checked

Hi folks I have a simple UserForm which has 3 checkboxes. Checkboxes labelled "Good" , "Average" and "Bad" When "Good" is checked, the value "1" is entered into a cell. If "Average" is checked then the value "0.5" is entered and "0" is entered when "Bad" is checked. The problem is this......I...

Hi Guys, Looking for a little help please. I have copied in a table from another source. The table has 500 lines of data. Each line of data contains a Checked box. I need to see which of the checked boxes are TRUE or FALSE. The table only has 4 columns with all checked boxes being in column...

Trying to have my email generating macro address it based on which radio button is checked on the excel worksheet. Getting "subscript out of range" on this line Set ws = ActiveWorkbook.Worksheets.Item("Sheet1") in below code Sub IfOptionButtonChecked() Dim ws As Excel.Worksheet Set ws =...

Hi, The goal is to Check multiple html checkbox options in a webform.Nothing works for me, probably due to a wrong approach & syntax. The vraiables that should to be checked are stored in 1 cell per line, and seperated with delimiter "|". For example - Cell J(i) contains: "roleA|RoleB|RoleC"...

Hello, I'm trying to create a check in/out system at a lab I work at. I'm not to experienced and using VBA. I was able to tinker with some formulas to get it to do what I wanted, but I wasn't fully successful in getting all the steps I wanted done. so what I'm trying to do is check in samples...

Hello, I've got a command button on userform that is checking a lot of options with one click. One of the things I need it to check is if all the OptionButtons (6 of them) are deselected. If so, a cell needs to populate a value. If any are clicked, I need it to move on to the rest of its task...

Dear experts, I have developed an user form to edit data base value. I have variables like, Application Number, Name, Assets, status of Income tax submitted. My requirement is, My edit form in user form. If i will give inputs of an application number, I want to get respective Name, assets and...

Hi, I've recently got the office 365 package as I have JSON files which I want to use within excel. When I select data > new query > get file > there is no option for JSON yet when I Google it the option should be there. Does anyone know how to fix this as I've checked the ribbon to make sure...

Hi everyone, I have data that is formatted like this: The real set goes on for about 1200 sets. What I need is the code after Copy: and the code after S: in separate columns to right. E.g. from the Row 1-2 entry I would get G123456789 and P 12345678. Similar for rows 3-4, nothing for row 5...

Hi all, Need help on macro to add a blank row whenever a checkbox is checked in column Q. I have provided a sample of the workbook.

I am trying to prepare professional charts for work and wanted to know if there is a good video showing how to make a great line chart? Also any other charts as well. Have checked youtube and so many I don;t know which one would be best to watch. Much appreciated! :confused:

I have a column that I place check marks in if a certain condition is met. Some cells are checked and some are empty. I need to find the row number of the last checked cell. There will be only check marks or empty cells in in this column. And thanks again for all the wonderful help in the past.

Hello everyone, Can someone help me with this? How do I condition column C based on the checkbox on column B? Column A_____________Column B___________Column C _Amount_____________checkbox_______________n% Cells from column C should reflect 15-20% from corresponding cells on column A If a...

Hello everybody. I have set up the instruction below that works perfectly (consider Rng is column C of a sheet). z = Application.CountIf(Rng, "CODE 37") Now, I have to count if also a second criteria is checked: in particular, on the same row of "CODE 37", the value in column B has to be <...

I have a spreadsheet in which I want to perform a BeforeDoubleClick command on. I have two ranges which are M3 to M49 (range 1) and M50 to M250 (Range2). In range one when i perform a doubleclick I want the contents of the cell to change from "NOT CHECKED" to "CHECKED" and the cell colour to...

Dear All I have a formula in one cell which is doing this, =8260&RIGHT(F6,6) and returns say this as a result 8260159860 then next to it I have a formula stating =MATCH(X6,'sheet1'!C:C,0) but it returns an error - if I manually type in the number 8260159860 it returns a figure correctly - I have...

I am running the following code to check if certain programs are running. ##This Script is for checking status of 3 processes TestMgr.exe, iTestConsole.exe and tdefine.exe in all testBed machines <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit...

Hi All, I am trying to get the last row count in excel using vba using the below code: lastrow = Cells(Rows.Count, "A").End(xlUp).Row but it is not giving me the required result. I am getting 1 as output. even though I checked manually that data is there and Ctrl+Shift+End is also taking me...

I have a vba code which works well up to a point, the code i'm using is as follows Private Sub Worksheet_BeforeDoubleclick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, Range("$L$3:$L$187")) Is Nothing Then Exit Sub Select Case Target Case "" Target =...

I know this is generally backwards from how its usually done (that is to say when a checkbox is checked the link to another cell the value changes to "1") but I need a macro that looks at a range of cells in a column; "O18:O386", which are all going to be either "1" or "0" , and if its a "1"...