Loop through checkbox and inputs data based on which is checked

**joe8904** · 03-10-2016, 12:39 PM

Hi,
Im pretty new to VBA,just 2 weeks now.
I'm trying to make a userform that does estimate of lengths for cables.
here's the problem:
I created a series of checkbox and trying to create a code that scans all the checked checkbox and outputs them accordingly.
ex. checkbox1 goes to cell(2,1) but if checkbox1 is not selected then checkbox2 goes to cell(2,1)..etc
How do i do this? Any help would be great..
heres my code so far

Please Login or Register  to view this content.

edited:
i think i added my file now

**mehmetcik** · 03-10-2016, 01:06 PM

You are going down a dead end.

You should have attached your spreadsheet, so I could correct your code for you.

Please Login or Register  to view this content.

**joe8904** · 03-10-2016, 03:13 PM

mehmetcik, I've edited my original post now. Will try your code to see if it works for my case.Thanks

**joe8904** · 03-10-2016, 05:48 PM

mehmetcik,
Didnt quite work the way I wanted it to do..but your code gave me some insight of cell selection. Will try to work out a cell selection type module and see if that solves my problem.

**joe8904** · 03-11-2016, 11:13 AM

Hey guys,
Here's my logic to what I meant in this bost.
The code I'm trying to create is designating one cell to multiple checkbox.caption but if that first checkbox is ticked in that set of checkboxes, the cell moves down for the next ticked checkbox.
That way at any instance a checkbox is ticked, the output will be sorted in each cell automatically without any gaps between the data.
I'm sure this is possible but haven't got the right syntax needed for the coding.
Please advise or provide with a code. All help is much appreciated

**joe8904** · 03-14-2016, 09:51 AM

Found my solution. Create an array to store the values and output it to each cell based on number of checkbox ticked.

Loop through checkbox and inputs data based on which is checked

LinkBack

Thread Tools

Rate This Thread

Display

Loop through checkbox and inputs data based on which is checked

Re: Loop through checkbox and inputs data based on which is checked

Re: Loop through checkbox and inputs data based on which is checked

Re: Loop through checkbox and inputs data based on which is checked

Re: Loop through checkbox and inputs data based on which is checked

Re: Loop through checkbox and inputs data based on which is checked

Thread Information

Users Browsing this Thread

Similar Threads

If checkbox checked then data validation

[SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false

Return data to datasheet when checkbox in the form is checked

[SOLVED] VBA code to uncheck checkbox 2 & 3 if checkbox 1 is checked

CheckBox copies data when checked but needs to also remove data when unchecked

[SOLVED] Excel VBA calculating Average based on checked CheckBox

Copy row data for checked checkbox

Bookmarks

Bookmarks

Posting Permissions