mutipage and optionbuttons

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TUNGANA KURMA RAJU - 31 May 2008 11:29 GMT

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.

Reply to this Message

Norman Jones - 31 May 2008 12:06 GMT

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

>I have a userform with 3 optionbuttons on a framecontrol.Right to this
>frame
[quoted text clipped - 8 lines]
> That means at any point of time only one page be diasplayed and be
> focussed.

Reply to this Message

TUNGANA KURMA RAJU - 31 May 2008 16:32 GMT

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

> Hi Tungana,
>
[quoted text clipped - 45 lines]
> > That means at any point of time only one page be diasplayed and be
> > focussed.

Reply to this Message

TUNGANA KURMA RAJU - 31 May 2008 17:40 GMT

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

> Hi Tungana,
>
[quoted text clipped - 45 lines]
> > That means at any point of time only one page be diasplayed and be
> > focussed.

Reply to this Message

Norman Jones - 31 May 2008 18:22 GMT

Hi Tungana,

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

---
Regards.
Norman

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

Reply to this Message