Excel VBA Forms and multiple checkboxes
 

Hello to all,

I am not a newbie to vba with excel, but I have never had to use forms
before.

My problem is this :

I have a form that has a checkbox for every period (P1 to P12). Behind
every checkbox, I want to assign a Range value for every Period
corresponding to somewhere in my excel sheet.

Dim Per1 As Range
Set Per1 = Range("D3:G34")
Dim Per2 As Range
Set Per2 = Range("H3:K34") and on it goes for all periods...

I want to command button to verify if only 3 checkboxes have the value
1 and then take the ranges from those selected textboxes and do :

Union(Perx,Pery,Perz)

How can I get this done???

So in resume...How can I assign a Range value to a checkbox and use
multiple checkboxes to do a union.

Thanks.....Francis