mutipage and optionbuttons

  • Thread starter Thread starter TUNGANA KURMA RAJU
  • Start date Start date
T

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.
 
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
'<<==========
 
Mr.Norman ,will you please look into my post dated 22ndMay,regarding various
TextBox Validations?
thank you..
 
Back
Top