| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Option Button question
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 bot 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 name differently, according to the tab number. Is there anyway I could answer both questions -- harpscardif ----------------------------------------------------------------------- harpscardiff's Profile: http://www.excelforum.com/member.php...fo&userid=2596 View this thread: http://www.excelforum.com/showthread.php?threadid=51816 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Option Button question
Use checkboxes not optionbuttons.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Option Button question
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Option Button question
Thanks for that - is there any way to have the check boxes set so tha they are blank -- harpscardif ----------------------------------------------------------------------- harpscardiff's Profile: http://www.excelforum.com/member.php...fo&userid=2596 View this thread: http://www.excelforum.com/showthread.php?threadid=51816 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Option Button question
Yeah,
cbExpired.Value = False -- HTH Bob Phillips (remove nothere from email address if mailing direct) "harpscardiff" wrote in message news:harpscardiff.241ikb_1141299301.5165@excelforu m-nospam.com... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Option Button question
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Option Button question
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Option Button question
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Button | Excel Discussion (Misc queries) | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
| Option button help | Excel Programming | |||
| option button | Excel Discussion (Misc queries) | |||
| Option button | Excel Programming | |||
![harpscardiff[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
