Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an optionbutton in a frame along with a variety of controls. I would
like to enable = True when the Option Button = True and visa versa. The code below works, but only for TextBoxes. Can this code work for all controls? Private Sub OptionButton13_Click() Dim ctrl As Control For Each ctrl In Me.Frame2.controls If TypeOf ctrl Is MsForms.TextBox Then ctrl.Enabled = OptionButton13.Value End If Next End Sub Thanks, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error saying Control object does not have Enable property. | Excel Programming | |||
MultiPage: How to enable controls in Frame on Page | Excel Programming | |||
ddm enable/disable: Object doesn't support this property, my a** it doesn't | Excel Discussion (Misc queries) | |||
How get a row number of the controls(sample:optionbutton) | Excel Programming | |||
Enable and disable worksheet controls? | Excel Programming |