Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Add a class module named Class1 (later name as say clsCBxEvnts)
' code in Class1 ' add other events, select cbx from the middle dropdown ' then other events from the right dropdown Public WithEvents cbx As MSForms.CheckBox Public tbx As MSForms.TextBox Private Sub cbx_Change() tbx.Enabled = cbx.Value End Sub ''Userform code ' two checkboxes named CheckBox1 & 2 ' two textboxes named TextBox1 & 2 Dim arrClsCBoxEvnts(1 To 2) As Class1 ' or say clsCBxEvnts Private Sub UserForm_Initialize() Dim i As Long For i = 1 To 2 Set arrClsCBoxEvnts(i) = New Class1 With arrClsCBoxEvnts(i) Set .cbx = Me.Controls("CheckBox" & i) Set .tbx = Me.Controls("TextBox" & i) .tbx.Enabled = .cbx.Value End With Next End Sub Regards, Peter T "fedude" wrote in message ... Joel, Is there a generic form change event that I can catch in a routine that then loops through the checkbox controls to see if they've changed? "Joel" wrote: Each check box must have a unique function. But all of the routines can have one instruction which call a common function. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Form Click event... | Excel Programming | |||
Click event for checkbox from Forms toolbar | Excel Discussion (Misc queries) | |||
Passing CheckBox Value from Click Event to Main Macro | Excel Programming | |||
Click Checkbox Event | Excel Programming | |||
Assigning click event to OleObjects checkbox | Excel Programming |