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.

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.

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.

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.

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..