checkboxes

Hi, I didn't think this would be difficult, but I've tied myself in knots with Google searches and am not proper confused !! I have a range of cells : A1:A10 I would like every cell in this range alone to have a check box Each check box should link to it's respective cell: A1, A2 etc.. Each...

I created a kind of calculator, here's where I'm stuck, and it's the last part of it. Let's say cell c4 has a value that is the base Now I have 4 choices (checkboxes) with values to choose from. When you select a choice, I need to add that value to the base value to come up with a total...

Hello, How to create two columns of checkboxes in one column (B) and give them names such as: cbSet1_01, cbSet1_02, cbSet1_03... and cbSet2_01, cbSet2_02, cbSet2_03.... I would like to link Set1 to column A and Set2 to column B. I googled but couldn't find an answer. Thanks for your...

Hey, I'm trying to create a macro which inputs certain info from each row into another sheet. But i want to use check boxes so i can select certain row and that tranfres only that line Helpppp:(

Good Afternoon, I have created a set of code which works in Excel 2010 and 2007 to do the following: 1.) User fills in form as per questions. 2.) User is asked if they have completed other requirements. 3.) Form unlocks checkbox options so user can continue with form. I am now seeing issues...

Hello, I am new to using macros and VB but am very familiar with other aspects of Excel. What I am working on is a spread sheet for writers for my newspaper. I have a spread sheet created Pictured here. What i would like to do is have it to where the person who makes pays our writers can...

Good Morning to my fellow Excel users, The issue that I am having today shouldn't be an issue but alas it is. What I thought would be a simple repair to my companies estimating sheet has turned into an almost brain bleeding painful task. All I am trying to do is link two check boxes on two...

I have a worksheet with some checkboxes in it (form control) and whenever I "save as" the file... they disappear (literally gone from the worksheet!) Any ideas why this might be happening?

I have a simple code to Select/Unselect all the checkboxes (Form Control) on the Active sheet. The code works in that the values of the target cell change correctly from TRUE to FALSE and visa versa.. BUT, the checkboxes themselves don't show the change (i.e., the check marks in the boxes...

I know how to track changes and view the history but can I track changes to checkboxes and option boxes?

Can someone help me add to the macro below to delete checkboxes with the row that is being deleted? The row is deleted per the macro, but the ticked checkbox transfers to new sheet. Sub EndofCycle() ActiveSheet.Copy After:=ActiveSheet Columns("AS").Select Selection.AutoFilter...

Hello all, Quick question. I'm writting a VBA code for a project i'm working on and I've exaughsted my google searching trying to figure this out. The problem I'm having is this. ActiveSheet.OLEObjects.Add ClassType:="Forms.CheckBox.1", _ Link:=False, _ DisplayAsIcon:=False, _...

my problem is checkboxes didnt tick, 'checkbox for slipsheets Dim checkboxes As CheckBox If Range("EU5").Value = "PALETIZED" Then checkboxes("Check Box 36").Value = xlOn Else checkboxes("Check Box 36").Value = xlOff End If If Range("EU5").Value = "LOOSE-LOADED"...

my problem is checkboxes didnt tick, 'checkbox for slipsheets Dim checkboxes As CheckBox If Range("EU5").Value = "PALETIZED" Then checkboxes("Check Box 36").Value = xlOn Else checkboxes("Check Box 36").Value = xlOff End If If Range("EU5").Value = "LOOSE-LOADED"...

Hey everyone, sorry if this answer is already out there, I have been searching for a week now without any luck. What I would like to do is have a UserForm that displays a check box to each item in a list, and if the column next to the item has a "Y", then the checkbox would appear already...

Hi I have inserted check boxes to a form im updating. I have linked these checkboxes to a cell. The checkboxes are for a 'table 1' of hazards ( there are 46 of them). Below table 1 is another table (table 2) that lists the items checked in the table above. I cant seem to find out how to...

I am trying to make a userform which pops up when a user opens my excel file. They must make a minimum of 1 selection from a list of checkboxes. If they select checkboxes 1, 2, and/or 3, I'd like the StartJE Command Button to activate to close the Userform (and essentially take them to the...

Greetings, I am working on a fairly complex model with lots of formatting and lots of checkboxes. I need a quick way to get all the cells with a checkbox unlocked so when I protect the sheet they are usable. I have lots of merged cells so just highlighting a column is a non-starter. Any help...

Ok, so I hate using checkboxes, but in this case I don't have a choice (The sheet was designed by someone else and has a ton of checkboxes that don't line up with individual cells, I am just writing some macros for it) So the macro copies a template worksheet, but when it does, every checkbox...