Checkbox Range in a For Next Loop

[jmacinnees]

Anybody know how to turn this into a For-Next Loop?
Both the CheckBox & Range need to increment by 1

CheckBox168.Top = Range("g185").Top
CheckBox169.Top = Range("g186").Top
CheckBox170.Top = Range("g187").Top
CheckBox171.Top = Range("g188").Top
CheckBox172.Top = Range("g189").Top
CheckBox173.Top = Range("g190").Top
CheckBox174.Top = Range("g191").Top
CheckBox175.Top = Range("g192").Top
CheckBox176.Top = Range("g193").Top
CheckBox177.Top = Range("g194").Top
CheckBox178.Top = Range("g195").Top
CheckBox179.Top = Range("g196").Top
CheckBox180.Top = Range("g197").Top
CheckBox181.Top = Range("g198").Top

[p24leclerc]

assuming you used ActiveX checkboxes, you can try this macro

Please Login or Register  to view this content.

and this one will work for Form control checkboxes:

Please Login or Register  to view this content.

[jmacinnees]

Outstanding!!!

This worked, thank you so much p24leclerc