mutipage and optionbuttons

[TUNGANA KURMA RAJU]

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.

 

[Norman Jones]

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
'<<==========

 

[TUNGANA KURMA RAJU]

Thank you ,Jones.you helped me many times.I sincerely appreciate your help.

 

[TUNGANA KURMA RAJU]

Mr.Norman ,will you please look into my post dated 22ndMay,regarding various
TextBox Validations?
thank you..

 

[Norman Jones]

Hi Tungana,

See my initial response and also note
Rick Rothstein's post.