checkboxes

  1. K

    Copy/paste rows of data to new sheet if checkbox is checked

    Hi, I am new here and not very good with VBA. But I need to know how to write a code that will copy and paste rows of information from one workbook to another if the checkbox is clicked. Basically I am creating an Estimating sheet that has 100s of rows of possible activities. I want my...
  2. M

    Check boxes on a userform

    I have created a template sheet that I will be using for my team to create quotation. I have generated the first part of the form that completes the pricing part. I have a userform that I want to use to select different conditions to a quotation. I want the user to be able to tick/check the...
  3. B

    Checkboxes Yes No

    Hello, I have the following code that I picked up from some web page. This one inserts only one button to the left of the cell. I would like to have two checkboxes in one cell, one for "Yes" another for "No" and only one can be checked. I tried to replicate second option by adding "1" to the...
  4. W

    Multipage and checkboxes

    I really hope this is possible. I need to program a command button to send an email via Outlook... I have multiple tabs on a multipage (each tab labeled as a product type) In each page I have a long list of product in as checkboxes. I need the "Submit" button to find all of the checked boxes...
  5. H

    Checkbox editing

    Hello. new to here need some help with checkbox and conditional formatting, ill explain my problem. i have a column, eg A, which has dates in, so different dates in each cell in column A i have set some conditional formatting to change the colour of the cells in A depending on the proximity of...
  6. C

    Listbox/checkbox edit

    Hello. On my userform i have 2 checkboxes (Checkbox1, Checkbox2), where the data from those checkboxes are stored in columns 11 and 12 on worksheets("Data") depending on which checkbox is selected. I have an edit button (btnEdit) which is clicked after selecting a row from a listbox (Listbox1)...
  7. M

    Strange behavior for Excel 365 when deleting pictures

    I have run across some strange behavior, and am wondering if anyone else has experienced this. I have a worksheet where the user can import pictures via VBA code. I also have a couple of checkboxes (form controls) on that sheet. I have a button that allows the user to clear the sheet of all...
  8. E

    How to detect if multiple checkboxes are selected

    I am creating an userform that have checkboxes users can tick off, and then press select files. I already have working code that corresponds to each of the checkboxes users can select, however I want to know if there's an efficient way to do this process. For example, let's say user wants to...
  9. T

    Set focus after tabbing through textboxes and checkboxes on sheet

    I have a sheet (not userform) with many ActiveX textboxes and checkboxes. It's used as a checklist for equipment inspections that gets printed out. Tabbing through the textboxes and checkboxes is hard coded on Sheet1 with: Private Sub CheckBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger...
  10. J

    Form Control Grouping Greyed Out

    Hi all, I'm creating a set of checkboxes for a multi-series chart so users can select which series to display. I'm trying to group them into a groupbox but the option is greyed out/disabled: I can create the Group Box via the Insert option on the Developer Tab I can create and format my...
  11. I

    Sub for Creating Checkboxes

    Hey guys. So I've managed to modify some coding I found here to insert checkboxes into a file I'm working on. I am trying to make it into a Macro that I would call from another macro that that would place checkboxes in the center of the Range I would give it.. ie. Call CB("A1:B5") And that would...
  12. MFish

    Resize columns through VBA

    Hi, I am making a userform with checkboxes that will be a "Filter what you want to see" action. When you checkmark a checkbox it will then hide the designated column. When you uncheck it, it reverts back to unhide. My problem I have is it works great until you unhide the column and the...
  13. K

    checkbox to check automatically IF any of other checkboxes are checked

    So here is a brief snippet of my userform i have to use as an example: the top right-hand box (where it says "miscellaneous incidents") has a transparent label over top of the box so it cannot be manually checked... (i put a single frame around it only so that it can be seen for my example...
  14. C

    Macro To Uncheck Checkboxes

    Is there a way to have a macro uncheck all checked checkboxes, except for some? <tbody> A B C 1 X X X 2 X 3 X X 4 </tbody> So if every X represents a checkbox, and most of them are checked, I want a macro that clears all the checks, except the checkboxes in row A...
  15. F

    VBA: Delete checkboxes in cell range

    I am trying to set up a macro that will search the range of cells for any checkboxes, and if there are any in the range, they will be deleted (and then I add new ones in the next step). However, when I run the macro, it deletes ALL checkboxes in the sheet, rather than just those that are within...
  16. R

    Taking cells from one workbook based on checkbox criteria of another workbook

    Hello all, I have two worksheets, TW and PP. In TW there is a userform that contains a variety of checkboxes, these determine the information I want to take from PP. There are 12 checkboxes for each month of the year, then four category checkboxes. As an example, if I select CBJAN, CBFEB...
  17. M

    Reconfigure Userform Layout based on IF statement

    I have a UserForm that has several "extra" checkboxes. These checkboxes are enabled in some scenarios, but I use an IF statement to hide them most of the time, based on what is going on in the worksheet. I have the checkboxes functioning properly, but because hiding them leaves a lot of empty...
  18. 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...
  19. M

    Is there a way to make a checkbox's Caption dynamic

    Hello Excelgurus, I've incorporated a bunch of checkboxes in my workbook. The captions of those checkboxes are the first names of staff members. I've added those checkboxes manually and I also manually changed the caption to that particular person's first name. I was wondering if it's possible...
  20. V

    Checkboxes - Trying arrangin them and/or formatting

    Hello! How are you all? Well, I have a problem, so let me first try to explain myself. I have a Table with a long list of items in Column A and I am trying set two Checkboxes in Column B and C. I found there is two ways to do this: with Form Controls and ActiveX. But they both have differents...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top