Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform frame control
Hi
I am trying to use a userform with 2 frames. On the intialize I would like frame2 to be all disable then on clicking frame1 be enable. Help!!! This code below does not work. Thanks in advance Jo Private Sub UserForm2_Initialize() Frame2.Controls = False End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform frame control
Hi
I cannot get this to work. May be I am asking the wrong question. I would like frame2 and all the option buttons within the frame 'greyed out'. I have the form linked to a commed button with the following code Private Sub CommandButton2_Click() UserForm2.show End Sub does this overide the intialize event? Thanks again Jo -----Original Message----- One possibility: Private Sub Frame1_Click() Frame2.Enabled = True End Sub Private Sub UserForm_Initialize() Frame2.Enabled = False End Sub This actually requires a click on the frame1, not on a control in frame1. Alter to suit your needs. -- Regards, Tom Ogilvy o wrote in message ... Hi I am trying to use a userform with 2 frames. On the intialize I would like frame2 to be all disable then on clicking frame1 be enable. Help!!! This code below does not work. Thanks in advance Jo Private Sub UserForm2_Initialize() Frame2.Controls = False End Sub . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform frame control
Private Sub Frame1_Click() Frame2.Enabled = True Dim ctrl As Control For Each ctrl In Frame2.Controls ctrl.Enabled = True Next End Sub Private Sub UserForm_Initialize() Dim ctrl As Control Frame2.Enabled = False For Each ctrl In Frame2.Controls ctrl.Enabled = False Next End Sub -- Regards, Tom Ogilvy Jo wrote in message ... Hi I cannot get this to work. May be I am asking the wrong question. I would like frame2 and all the option buttons within the frame 'greyed out'. I have the form linked to a commed button with the following code Private Sub CommandButton2_Click() UserForm2.show End Sub does this overide the intialize event? Thanks again Jo -----Original Message----- One possibility: Private Sub Frame1_Click() Frame2.Enabled = True End Sub Private Sub UserForm_Initialize() Frame2.Enabled = False End Sub This actually requires a click on the frame1, not on a control in frame1. Alter to suit your needs. -- Regards, Tom Ogilvy o wrote in message ... Hi I am trying to use a userform with 2 frames. On the intialize I would like frame2 to be all disable then on clicking frame1 be enable. Help!!! This code below does not work. Thanks in advance Jo Private Sub UserForm2_Initialize() Frame2.Controls = False End Sub . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sow do i make a userform know if a value is true in a frame, then | Excel Discussion (Misc queries) | |||
Updating .tag in Userform Control in VBA | Excel Programming | |||
Missing ActiveX Frame control in Excel 2000 | Excel Programming | |||
UserForm Control | Excel Programming | |||
UserForm Control | Excel Programming |