Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mutipage and optionbuttons
I have a userform with 3 optionbuttons on a framecontrol.Right to this frame
I have a multipage control with 3 pages.I am unable to connect(Visible & focus) mutipage with these 3 optionbuttons. I need to connect them in such way, whenever the userform opened optionbutton1 be selected and page1 be displayed-this is default setting to be set. if optionbutton2 selected,page 2 be visible and focussed,and if optionbutton3 selected page3 be visible and focussed. That means at any point of time only one page be diasplayed and be focussed. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
mutipage and optionbuttons
Hi Tungana,
In the Userform module, try something like: '========== Option Explicit '------------- Private Sub UserForm_Initialize() With Me .MultiPage1.Value = 0 .OptionButton1.Value = True End With End Sub '------------- Private Sub OptionButton1_Click() Me.MultiPage1.Value = 0 End Sub '------------- Private Sub OptionButton2_Click() Me.MultiPage1.Value = 1 End Sub Private Sub OptionButton3_Click() Me.MultiPage1.Value = 2 End Sub '<<========== --- Regards. Norman "TUNGANA KURMA RAJU" wrote in message ... I have a userform with 3 optionbuttons on a framecontrol.Right to this frame I have a multipage control with 3 pages.I am unable to connect(Visible & focus) mutipage with these 3 optionbuttons. I need to connect them in such way, whenever the userform opened optionbutton1 be selected and page1 be displayed-this is default setting to be set. if optionbutton2 selected,page 2 be visible and focussed,and if optionbutton3 selected page3 be visible and focussed. That means at any point of time only one page be diasplayed and be focussed. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
mutipage and optionbuttons
Thank you ,Jones.you helped me many times.I sincerely appreciate your help.
"Norman Jones" wrote: Hi Tungana, In the Userform module, try something like: '========== Option Explicit '------------- Private Sub UserForm_Initialize() With Me .MultiPage1.Value = 0 .OptionButton1.Value = True End With End Sub '------------- Private Sub OptionButton1_Click() Me.MultiPage1.Value = 0 End Sub '------------- Private Sub OptionButton2_Click() Me.MultiPage1.Value = 1 End Sub Private Sub OptionButton3_Click() Me.MultiPage1.Value = 2 End Sub '<<========== --- Regards. Norman "TUNGANA KURMA RAJU" wrote in message ... I have a userform with 3 optionbuttons on a framecontrol.Right to this frame I have a multipage control with 3 pages.I am unable to connect(Visible & focus) mutipage with these 3 optionbuttons. I need to connect them in such way, whenever the userform opened optionbutton1 be selected and page1 be displayed-this is default setting to be set. if optionbutton2 selected,page 2 be visible and focussed,and if optionbutton3 selected page3 be visible and focussed. That means at any point of time only one page be diasplayed and be focussed. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
mutipage and optionbuttons
Mr.Norman ,will you please look into my post dated 22ndMay,regarding various
TextBox Validations? thank you.. "Norman Jones" wrote: Hi Tungana, In the Userform module, try something like: '========== Option Explicit '------------- Private Sub UserForm_Initialize() With Me .MultiPage1.Value = 0 .OptionButton1.Value = True End With End Sub '------------- Private Sub OptionButton1_Click() Me.MultiPage1.Value = 0 End Sub '------------- Private Sub OptionButton2_Click() Me.MultiPage1.Value = 1 End Sub Private Sub OptionButton3_Click() Me.MultiPage1.Value = 2 End Sub '<<========== --- Regards. Norman "TUNGANA KURMA RAJU" wrote in message ... I have a userform with 3 optionbuttons on a framecontrol.Right to this frame I have a multipage control with 3 pages.I am unable to connect(Visible & focus) mutipage with these 3 optionbuttons. I need to connect them in such way, whenever the userform opened optionbutton1 be selected and page1 be displayed-this is default setting to be set. if optionbutton2 selected,page 2 be visible and focussed,and if optionbutton3 selected page3 be visible and focussed. That means at any point of time only one page be diasplayed and be focussed. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
mutipage and optionbuttons
Hi Tungana,
See my initial response and also note Rick Rothstein's post. --- Regards. Norman "TUNGANA KURMA RAJU" wrote in message ... Mr.Norman ,will you please look into my post dated 22ndMay,regarding various TextBox Validations? thank you.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutipage | Excel Programming | |||
Mutipage | Excel Programming | |||
MutiPage control question | Excel Programming | |||
Extracting a Single Worksheet froma Mutipage Workbook | Excel Discussion (Misc queries) | |||
OptionButtons | Excel Programming |