checked

  1. G

    UserForm Checkbox

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

    Convert Column of Checked Boxes to TRUE or FALSE

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

    If OptionButton Checked Then

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

    Vba: Check multiple options in html checkbox

    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"...
  5. C

    check in- check out sytem using a barcode scanner

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

    Write to cell if all OptionButtons are deselected

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

    Data base edit through user form

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

    Missing JSON file option

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

    Extracting Some Data

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

    Checkbox as trigger to run macro

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

    Best videos to make professional charts

    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:
  12. A

    Last check mark in a column

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

    Check box condition

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

    Vba: Application.CountIf with more than one criteria

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

    BeforeDoubleClick

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

    issue with Match formula

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

    RPC server unavailable - win7

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

    Get row count of last row in sheet using VBA

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

    Beforedoubleclick VBA Code not completing process

    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 =...
  20. K

    code to check a checkbox if value of cell is "1"

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    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
    [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
    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
    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
    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
    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