LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default VBA Option Button question

Ah, of course !

Regards,
Peter

"Bob Phillips" wrote in message
...
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
...
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" wrote in message
...
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
...
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"


wrote in message
...

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











 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Option Button Pieter van der Walt Excel Discussion (Misc queries) 2 March 27th 06 12:02 PM
keep source formatting is not an option in paste option button Tina Excel Discussion (Misc queries) 0 February 20th 06 09:58 PM
Option button help justaguyfromky Excel Programming 1 September 5th 05 10:17 PM
option button Mario Excel Discussion (Misc queries) 1 July 26th 05 07:44 PM
Option button Jennifer Excel Programming 3 April 15th 05 10:28 PM


All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"