Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms - Checkboxes | Excel Worksheet Functions | |||
creating checkboxes from forms tool bar | Excel Worksheet Functions | |||
how do you insert multiple simple checkboxes in an Excel Spreadshe | Excel Discussion (Misc queries) | |||
Excel VBA Problem - Clearing multiple checkboxes | Excel Programming | |||
Can you hide forms checkboxes | Excel Programming |