I have two frames on a userform, Frame 2 and Frame 3. When the userform starts up, Frame 3 is disabled, but still visible (E.G: It's light grey and impossible to select). I did this by using the following code:
Dim ctrl As Control
For Each ctrl In Frame3.Controls
ctrl.Enabled = Not ctrl.Enabled
Next
Now what I want to do is when I click commandbutton1, for Frame 2 to become disabled, and frame 3 to become enabled. But what code do I need to put into the commandbutton's click event?
Help me, I'm at my wit's end!! Even my pigtails are going curly!!
Thanks
Janie
xxxx
Dim ctrl As Control
For Each ctrl In Frame3.Controls
ctrl.Enabled = Not ctrl.Enabled
Next
Now what I want to do is when I click commandbutton1, for Frame 2 to become disabled, and frame 3 to become enabled. But what code do I need to put into the commandbutton's click event?
Help me, I'm at my wit's end!! Even my pigtails are going curly!!
Thanks
Janie
xxxx