VBA Option Button question

[harpscardiff]

Hi,

Im my form, i've got two questions both require a yes/no answer.

The problem i'm getting is that I can't select an option for both questions.

Public Sub UserForm_Initialize()
optexpiredY1.Value = ""
optexpiredN1.Value = ""
optlockedY1.Value = ""
optlockedN1.Value = ""

I have a multipage of 6 tabs 4 tabs have the same questions, but named differently, according to the tab number.


Is there anyway I could answer both questions?

[Bob Phillips]

Use checkboxes not optionbuttons.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"harpscardiff" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> Im my form, i've got two questions both require a yes/no answer.
>
> The problem i'm getting is that I can't select an option for both
> questions.
>
> Public Sub UserForm_Initialize()
> optexpiredY1.Value = ""
> optexpiredN1.Value = ""
> optlockedY1.Value = ""
> optlockedN1.Value = ""
>
> I have a multipage of 6 tabs 4 tabs have the same questions, but named
> differently, according to the tab number.
>
>
> Is there anyway I could answer both questions?
>
>
> --
> harpscardiff
> ------------------------------------------------------------------------
> harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
> View this thread: http://www.excelforum.com/showthread...hreadid=518165
>

[Peter T]

If you particularly need Option buttons and not checkboxes, put each set of
buttons in separate frames.

To disguise use of frames you could set the SpecialEffect property of the
frame to 0/flat and remove caption.

Regards,
Peter T

"harpscardiff" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> Im my form, i've got two questions both require a yes/no answer.
>
> The problem i'm getting is that I can't select an option for both
> questions.
>
> Public Sub UserForm_Initialize()
> optexpiredY1.Value = ""
> optexpiredN1.Value = ""
> optlockedY1.Value = ""
> optlockedN1.Value = ""
>
> I have a multipage of 6 tabs 4 tabs have the same questions, but named
> differently, according to the tab number.
>
>
> Is there anyway I could answer both questions?
>
>
> --
> harpscardiff
> ------------------------------------------------------------------------
> harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
> View this thread: http://www.excelforum.com/showthread...hreadid=518165
>

[harpscardiff]

Thanks for that - is there any way to have the check boxes set so that they are blank?

[Bob Phillips]

Yeah,

cbExpired.Value = False

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"harpscardiff" <[email protected]>
wrote in message
news:[email protected]...
>
> Thanks for that - is there any way to have the check boxes set so that
> they are blank?
>
>
> --
> harpscardiff
> ------------------------------------------------------------------------
> harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
> View this thread: http://www.excelforum.com/showthread...hreadid=518165
>

[Tom Ogilvy]

Easier (IMO) would be to give each set a separate groupname property. It
doesn't make any difference what it is, just so it is unique among sets and
common within sets of optionbuttons.

--
Regards,
Tom Ogilvy

"Peter T" <peter_t@discussions> wrote in message
news:[email protected]...
> If you particularly need Option buttons and not checkboxes, put each set
of
> buttons in separate frames.
>
> To disguise use of frames you could set the SpecialEffect property of the
> frame to 0/flat and remove caption.
>
> Regards,
> Peter T
>
> "harpscardiff" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > Hi,
> >
> > Im my form, i've got two questions both require a yes/no answer.
> >
> > The problem i'm getting is that I can't select an option for both
> > questions.
> >
> > Public Sub UserForm_Initialize()
> > optexpiredY1.Value = ""
> > optexpiredN1.Value = ""
> > optlockedY1.Value = ""
> > optlockedN1.Value = ""
> >
> > I have a multipage of 6 tabs 4 tabs have the same questions, but named
> > differently, according to the tab number.
> >
> >
> > Is there anyway I could answer both questions?
> >
> >
> > --
> > harpscardiff
> > ------------------------------------------------------------------------
> > harpscardiff's Profile:
> http://www.excelforum.com/member.php...o&userid=25960
> > View this thread:
http://www.excelforum.com/showthread...hreadid=518165
> >
>
>

[Peter T]

Help > GroupName agrees with you -

"GroupName is more efficient for the following reasons...."

Frames also have advantages depending on what else might want to do.

Not sure why the OP is going the checkbox route, sets of optionbuttons would
seem suitable for each mutually exclusive "yes/no" pair.

Regards,
Peter T

"Tom Ogilvy" <[email protected]> wrote in message
news:#[email protected]...
> Easier (IMO) would be to give each set a separate groupname property. It
> doesn't make any difference what it is, just so it is unique among sets
and
> common within sets of optionbuttons.
>
> --
> Regards,
> Tom Ogilvy
>
> "Peter T" <peter_t@discussions> wrote in message
> news:[email protected]...
> > If you particularly need Option buttons and not checkboxes, put each set
> of
> > buttons in separate frames.
> >
> > To disguise use of frames you could set the SpecialEffect property of
the
> > frame to 0/flat and remove caption.
> >
> > Regards,
> > Peter T
> >
> > "harpscardiff"
<[email protected]>
> > wrote in message
> > news:[email protected]...
> > >
> > > Hi,
> > >
> > > Im my form, i've got two questions both require a yes/no answer.
> > >
> > > The problem i'm getting is that I can't select an option for both
> > > questions.
> > >
> > > Public Sub UserForm_Initialize()
> > > optexpiredY1.Value = ""
> > > optexpiredN1.Value = ""
> > > optlockedY1.Value = ""
> > > optlockedN1.Value = ""
> > >
> > > I have a multipage of 6 tabs 4 tabs have the same questions, but named
> > > differently, according to the tab number.
> > >
> > >
> > > Is there anyway I could answer both questions?
> > >
> > >
> > > --
> > > harpscardiff
> >
> ------------------------------------------------------------------------
> > > harpscardiff's Profile:
> > http://www.excelforum.com/member.php...o&userid=25960
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=518165
> > >
> >
> >
>
>

[Bob Phillips]

have 2 controls when one would do?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Peter T" <peter_t@discussions> wrote in message
news:[email protected]...
> Help > GroupName agrees with you -
>
> "GroupName is more efficient for the following reasons...."
>
> Frames also have advantages depending on what else might want to do.
>
> Not sure why the OP is going the checkbox route, sets of optionbuttons
would
> seem suitable for each mutually exclusive "yes/no" pair.
>
> Regards,
> Peter T
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:#[email protected]...
> > Easier (IMO) would be to give each set a separate groupname property.
It
> > doesn't make any difference what it is, just so it is unique among sets
> and
> > common within sets of optionbuttons.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Peter T" <peter_t@discussions> wrote in message
> > news:[email protected]...
> > > If you particularly need Option buttons and not checkboxes, put each
set
> > of
> > > buttons in separate frames.
> > >
> > > To disguise use of frames you could set the SpecialEffect property of
> the
> > > frame to 0/flat and remove caption.
> > >
> > > Regards,
> > > Peter T
> > >
> > > "harpscardiff"
> <[email protected]>
> > > wrote in message
> > > news:[email protected]...
> > > >
> > > > Hi,
> > > >
> > > > Im my form, i've got two questions both require a yes/no answer.
> > > >
> > > > The problem i'm getting is that I can't select an option for both
> > > > questions.
> > > >
> > > > Public Sub UserForm_Initialize()
> > > > optexpiredY1.Value = ""
> > > > optexpiredN1.Value = ""
> > > > optlockedY1.Value = ""
> > > > optlockedN1.Value = ""
> > > >
> > > > I have a multipage of 6 tabs 4 tabs have the same questions, but
named
> > > > differently, according to the tab number.
> > > >
> > > >
> > > > Is there anyway I could answer both questions?
> > > >
> > > >
> > > > --
> > > > harpscardiff
> > >
> > ------------------------------------------------------------------------
> > > > harpscardiff's Profile:
> > > http://www.excelforum.com/member.php...o&userid=25960
> > > > View this thread:
> > http://www.excelforum.com/showthread...hreadid=518165
> > > >
> > >
> > >
> >
> >
>
>

[Peter T]

Ah, of course !

Regards,
Peter

"Bob Phillips" <[email protected]> wrote in message
news:#[email protected]...
> have 2 controls when one would do?
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Peter T" <peter_t@discussions> wrote in message
> news:[email protected]...
> > Help > GroupName agrees with you -
> >
> > "GroupName is more efficient for the following reasons...."
> >
> > Frames also have advantages depending on what else might want to do.
> >
> > Not sure why the OP is going the checkbox route, sets of optionbuttons
> would
> > seem suitable for each mutually exclusive "yes/no" pair.
> >
> > Regards,
> > Peter T
> >
> > "Tom Ogilvy" <[email protected]> wrote in message
> > news:#[email protected]...
> > > Easier (IMO) would be to give each set a separate groupname property.
> It
> > > doesn't make any difference what it is, just so it is unique among
sets
> > and
> > > common within sets of optionbuttons.
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Peter T" <peter_t@discussions> wrote in message
> > > news:[email protected]...
> > > > If you particularly need Option buttons and not checkboxes, put each
> set
> > > of
> > > > buttons in separate frames.
> > > >
> > > > To disguise use of frames you could set the SpecialEffect property
of
> > the
> > > > frame to 0/flat and remove caption.
> > > >
> > > > Regards,
> > > > Peter T
> > > >
> > > > "harpscardiff"
> > <[email protected]>
> > > > wrote in message
> > > > news:[email protected]...
> > > > >
> > > > > Hi,
> > > > >
> > > > > Im my form, i've got two questions both require a yes/no answer.
> > > > >
> > > > > The problem i'm getting is that I can't select an option for both
> > > > > questions.
> > > > >
> > > > > Public Sub UserForm_Initialize()
> > > > > optexpiredY1.Value = ""
> > > > > optexpiredN1.Value = ""
> > > > > optlockedY1.Value = ""
> > > > > optlockedN1.Value = ""
> > > > >
> > > > > I have a multipage of 6 tabs 4 tabs have the same questions, but
> named
> > > > > differently, according to the tab number.
> > > > >
> > > > >
> > > > > Is there anyway I could answer both questions?
> > > > >
> > > > >
> > > > > --
> > > > > harpscardiff
> > > >
> >
> ------------------------------------------------------------------------
> > > > > harpscardiff's Profile:
> > > > http://www.excelforum.com/member.php...o&userid=25960
> > > > > View this thread:
> > > http://www.excelforum.com/showthread...hreadid=518165
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>