Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBox
Hi
I have one UserForm1 with 14 CheckBox All are Enabled = false I would like make part of these checkBox Enabled=True And Show the userForm1 with all checkBox some enabled other disabled to permit to check only some of checkboxes Enabled. Sub Print_period() Dim Cbk As CheckBox Dim Count As Integer Dim Prd As Integer Prd = 5 Count = 0 For Each Cbk In UserForm1.checkbox '13 checkbox Count = Count + 1 If Count < Prd Then Cbx.Enabled = True End If Next UserForm1.Show But Something is wrong. Thank you for your help. Jean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
CHECKBOX HELP | Excel Programming | |||
link a checkbox in a sheet to a checkbox on a userform? | Excel Programming | |||
How do I link one checkbox to update another checkbox? | Excel Programming | |||
checkbox on form reset from checkbox on sheet | Excel Programming |