Create an array for many checkboxes

I have 10 checkboxes within my userform and they show their corresponding page when ticked and then hides when unticked within the multipage. I currently have it set to each has their own Sub below is example

Private Sub CBks_Click()
    MultiPage1.pages(4).Visible = CBks.Value ' Checkbox Kiwisaver Tab
End Sub

Private Sub CBh_Click()
    MultiPage1.pages(5).Visible = CBh.Value ' Checkbox House Tab
End Sub

Private Sub CBip_Click()
    MultiPage1.pages(6).Visible = CBip.Value ' Checkbox Saturn Investment Tab
End Sub

How could I put all of these into an array?

edited Feb 10 at 22:46

jonrsharpe

123k31 gold badges277 silver badges488 bronze badges

asked Feb 10 at 22:43

NoFafo

111 silver badge2 bronze badges

There are plenty of posts here about using a "control array" to handle events in VBA. Eg: stackoverflow.com/questions/37407974/… (checkboxes) or stackoverflow.com/questions/71517600/… (textboxes)

Tim Williams
– Tim Williams

2025-02-10 23:00:14 +00:00
Commented Feb 10 at 23:00
...but unless you're adding checkboxes dynamically, creating a control array likely isn't going to end up as less code than you already have.

Tim Williams
– Tim Williams

2025-02-10 23:02:37 +00:00
Commented Feb 10 at 23:02
...and the answer to your previous question also shows how to use that approach stackoverflow.com/a/79395333/478884

Tim Williams
– Tim Williams

2025-02-10 23:23:31 +00:00
Commented Feb 10 at 23:23

Add a comment |

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.

Collectives™ on Stack Overflow

Create an array for many checkboxes [duplicate]

0

Linked

Hot Network Questions