| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through checkboxes
I have a macro that has a pair of loops in it. I have inserted checkboxes
into the sheet to enable the user to skip certain lines when the macro runs. The problem is I have Checkbox1, checkbox2, and so on. For myLine = 1 To 5 If Sheet1.Checkbox1 = True Then myPath = dirPath & ... & mySheet & "'!E24" ActiveCell.Value = "='" & myPath Cells(ActiveCell.Row + 1, 2).Select Else Cells(ActiveCell.Row + 1, 2).Select End If Next myLine I want to use the "myLine" counter in the loop to check each checkbox for the True condition. I am sure there is a simple way, I just cannot seem to figure it out. Any help would be appreciated. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping through checkboxes
I was able to get it, please disregard. Thanks!
"TomK76" wrote: I have a macro that has a pair of loops in it. I have inserted checkboxes into the sheet to enable the user to skip certain lines when the macro runs. The problem is I have Checkbox1, checkbox2, and so on. For myLine = 1 To 5 If Sheet1.Checkbox1 = True Then myPath = dirPath & ... & mySheet & "'!E24" ActiveCell.Value = "='" & myPath Cells(ActiveCell.Row + 1, 2).Select Else Cells(ActiveCell.Row + 1, 2).Select End If Next myLine I want to use the "myLine" counter in the loop to check each checkbox for the True condition. I am sure there is a simple way, I just cannot seem to figure it out. Any help would be appreciated. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looping Checkboxes in Worksheet | Excel Programming | |||
| Looping through a group of checkboxes | Excel Programming | |||
| Looping Checkboxes on Worksheet | Excel Programming | |||
| Checkboxes to spreadsheet using a looping macro | Excel Programming | |||
| Looping checkboxes embedded in worksheet | Excel Programming | |||
Hybrid Mode
