mutipage and optionbuttons

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

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

TUNGANA KURMA RAJU

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

TUNGANA KURMA RAJU

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top