checkbox

Hey, guys. I put some CheckBoxes in my Form and make all of them invisible. Then I want to make only a few of them visible according to the number of Itens that the 'User' insert on a ListBox from the past Form. I also want to change the captions of these CheckBox to the same name of the itens...

Hi. I have an excel file which has 2 sheet and so many values in there. Sheet 2 has 32 product items. And sheet 1 is my invoice. I want to add a checkbox in sheet 2 so whenever I check on an item it automatically includes in sheet 1. Serially... I attached 3 images so things get more clear.

Hello i am trying to use a checkbox to add the current time in one cell and then add a number to another cell. e.g. cell (B1) 10:31am - cell (C1) 1 then if i untick the checkbox, ti is clear. can anyone please help.

I have over a dozen checkboxes. They are titled checkbox1, checkbox2, checkbox3... etc. They each have a sub routine that tells them what to do when click. These subroutines are identical except for the number that indexes each checkbox. While this was easy to create using copy/paste. It is...

Hi all, I'm in need of a Check Box in Drop down list for multiple selection. The code which i had is given below. The disadvantages of the given code was duplication and unable to edit the selection. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As...

I have a sheet where I have a checkbox that is entering TRUE or FALSE into a cell. For some reason I can't seem to get those values to control the conditional formatting for that row based on those text inputs. I have a rule already setup when that cell contains "n". Is there a way I can...

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

I have what should be a simple piece of VBA code to put together, but for the life of me i am hitting a brick wall. i am taking a VBA class but the prof is having us write code that isn't in the book or maybe we haven't covered yet. i have a (form) button that needs to be used to toggle a...

Through intellisense, I cannot find the backcolor fill setting for a checkbox shape within an Excel spreadsheet. I've used the "With" statement to make sure I'm selecting the one-and-only checkbox on the spreadsheet as well as the entire workbook. I'm not sure why this doesn't work? With...

Hi all, I know some of what I am doing is not the best possible solution but work with me. I have combobox that is populated from an access table. That works great. Now I have a checkbox that I use to update the checkbox field(Yes/No) in the same table based on the combobox selection. That too...

Hi Guys, Please help me on my project. I am creating an inventory/monitoring form that I have a multiple checkbox on my userform and when when i tick the checkbox1 it will automatically go on that particular sheet. I made a simple program like this. Sheets("Apple").Visible =...

Hi Guys, Good day. I have a project that i need your help and it goes like this. I will be using a multiple check box and if i tick a checkbox it would automatically go to a certain sheet. Thanks for your advance help.

Hi All I have a Office 365 spreadsheet with 23 check boxes for categories for sweets (the check boxes either hide or show a row in another sheet). I also want to add a couple of check Boxes that will select all the "chocolate" (checkbox 24) sweets and deselect the remainder or select all the...

Once again I bow to the superior knowledge of the group to see if I what i want to do can be done. I have a user from that is the first part of a mass email script that I am trying to write. What I would like is select one or several checkboxes in the first frame and then select 1 optionbutton...

Hello, I am making a form. I have a checkbox1 and checkbox2. I want to make it such that whenever checkbox1 is checked then everything already entered in textbox1, textbox2 and Listbox1 is automatically deleted. So I want to have the above controls blank when the checkbox 1 is checked Please...

I am still struggling with trying got do this. When I activate my userform, if a cell on the worksheet has a value greater than 0 I wan the checkbox to be checked. Currently if checked when unloading it runs a macro and put data in the cell if it is checked. However if you don't recheck it the...

I have inserted an excel table into my spreadsheet and I need to be able to update all rows of the table in column M with a 1 if a checkbox isn't selected and a 1.1 if it is selected. The table starts in column A and it is called npss_quote. The checkbox is called chkincrease. Can someone please...

Good Day, I have a worksheet that is essentially a checklist to be completed. For each section it contains line items and each line item has a checkbox for "Yes", "No", & N/A. I am no VBA expert by any means but would like to covert to a PDF document and maintain the checkbox functionality. I...

Hello, I have a document that has a couple of sheets. Sheet 1 has 3 rate plans 1. Basic 2. Standard 3. Platinum Each rate plan has the inclusions documented on another sheet in the same workbook. What I would like to know is it possible for a rate plan to be selected and the inclusions on...

Hi, I have a listbox that is populated based on usernames listed in cells A5-A24. Each username has a checkbox, if the checkbox is selected, I need to send an email with an attachment to that user. I have each of the associated emails listed in column F. The macro I have first creates and...