Greetings Fellow users,
I have created checkboxes for 74 rows ("D5:D74")
If checked I would like to copy items is ("B5:B74")
Any help would be greatly appreciated
Posts by ssgbabb
-
-
Rory!!! It works Thank you so much !!!!
-
I was testing it, so thats the problem i need to all all the check boxes.
-
Here is a screen shot it, after I close it all the rows populate but I a, getting error message, see attached.. I see light at the end of the tunnel
-
You are an amazing help, hopefully i can get this project done by close of business.
I cant get the code to work, i dont know what im doing wrong, but im watching a video , because i put the code in the command button, but its not populating the cells when i press submit/
-
Thanks im going to give it a try, for my general knowledge outrow =52 (is that me setting start point for data population?)
-
Sorry for not clarifying myself, it should populate in sequence A52, A53.....and so on, since not all check boxes will be used im guessing next available row
-
Good Morning Rory,
First off thank you for the help.
Each item checked should populate Rows A52 through A64
-
Thanks Rory,
The user will select multiple checkboxes, I initially tried option buttons, but they limited me to 1 selection, that's why I chose to use checkboxes. If you look at my snapshot I have the userform open up and the user selects which options are best for him/her and the data will be placed in cells A53:A65
-
I am currently working on a project where I have 20 checkboxes , what I am trying to accomplish is if checked, the checkbox caption will be put in a cell range A52:A63. I cant seem to figure out how to do the looping or even if I am on the right track. this is my code below which is simple but I'm sure it should be more complex than this. I have also attached an example of what I'm trying to do. I am not asking for anyone to do my work for me, I want to learn, I am a beginner. Any help would be greatly appreciate.
Code
Display MorePrivate Sub Insertdata_Click() If CheckBox1.Value = True Then ActiveCell.Value = CheckBox1.Caption ElseIf CheckBox2.Value = True Then ActiveCell.Value = CheckBox2.Caption ElseIf CheckBox3.Value = True Then ActiveCell.Value = CheckBox3.Caption ElseIf CheckBox4.Value = True Then ActiveCell.Value = CheckBox4.Caption End If End Sub