Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 8th 05, 07:37 PM posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Entry into check box dependent on other check box.

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!

  #2   Report Post  
Old December 8th 05, 08:28 PM posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Entry into check box dependent on other check box.

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!

  #3   Report Post  
Old December 8th 05, 08:46 PM posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Entry into check box dependent on other check box.

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!

  #4   Report Post  
Old December 8th 05, 11:12 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Entry into check box dependent on other check box.

How about using optionbuttons? That's the way they behave.

You may want to try this:
http://www.contextures.com/xlform01.html

Stilla wrote:

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!


--

Dave Peterson
  #5   Report Post  
Old December 9th 05, 09:50 PM posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Entry into check box dependent on other check box.

Hello again Dave! Thank you for replying to my question and for waking me up
to OPTION BUTTONS!! THe link you sent was very impressive... and the
example is sort of similar to my situation. I don't know VBA though, and my
experience with macros is about a week old... So, I'm trying to do what I can
just using menus and control functions.

I have experimented with the various control functions...and it seems like I
am SOOO close, but I don't know whether I can get what I want without using
code.

The "listbox" is the closest thing... The listbox lets me make a vertical
list of entries with a vertical column of buttons. BUT..but what I'd like
to do is have this type of structu
Strong Avg Weak
question 1 button button button
question 2 button button button
question 3 button button button
question 4 button button button

Is there anyway I can do this using control toolbox/properties, without
writing code? Another limitation is that I don't want macros attached to the
form.

Thanks again..


"Dave Peterson" wrote:

How about using optionbuttons? That's the way they behave.

You may want to try this:
http://www.contextures.com/xlform01.html

Stilla wrote:

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!


--

Dave Peterson



  #6   Report Post  
Old December 9th 05, 10:31 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Entry into check box dependent on other check box.

Make your rowheights slightly larger (so you can fit the option buttons and
groupbox nicely).

Say you're going to start with Row 3 (headers in rows 1&2).

Show the Forms toolbar
click on the groupbox icon and then draw that groupbox within row 3.
Now click on the optionbutton icon on that same toolbar
Draw an optionbutton with in that groupbox
click on that option button and drag it within the groupbox (2nd button)
and do it once more for the 3rd button.

Line things up as best you can.

Rightclick on any of the 3 optionbuttons and select format control
on the control tab, type in the address of the cell that should be used as the
cell link.

Now show the drawing toolbar.
click on that arrow icon
lasso the groupbox (that'll include the 3 option buttons)

now ctrl-click and drag it to a new row.
You'll have to change the linked cell manually, though.

Repeat for as many rows as you want.

The macro tries to do all that junk for you. You may want to try it.

Stilla wrote:

Hello again Dave! Thank you for replying to my question and for waking me up
to OPTION BUTTONS!! THe link you sent was very impressive... and the
example is sort of similar to my situation. I don't know VBA though, and my
experience with macros is about a week old... So, I'm trying to do what I can
just using menus and control functions.

I have experimented with the various control functions...and it seems like I
am SOOO close, but I don't know whether I can get what I want without using
code.

The "listbox" is the closest thing... The listbox lets me make a vertical
list of entries with a vertical column of buttons. BUT..but what I'd like
to do is have this type of structu
Strong Avg Weak
question 1 button button button
question 2 button button button
question 3 button button button
question 4 button button button

Is there anyway I can do this using control toolbox/properties, without
writing code? Another limitation is that I don't want macros attached to the
form.

Thanks again..

"Dave Peterson" wrote:

How about using optionbuttons? That's the way they behave.

You may want to try this:
http://www.contextures.com/xlform01.html

Stilla wrote:

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!


--

Dave Peterson


--

Dave Peterson
  #7   Report Post  
Old December 10th 05, 02:55 AM posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Entry into check box dependent on other check box.

Dave! This is so terrific! I did it! Just like you said - it worked! I am
sooo happy! I'm going to curl up on the couch and have fun with my form
now.. I love doing this stuff.

So it's the "group box" that makes the magic happen - that makes it possible
to just choose one of the three buttons - wow..! isn't excel just
incredible!?

THANK YOU THANK YOU!


"Dave Peterson" wrote:

Make your rowheights slightly larger (so you can fit the option buttons and
groupbox nicely).

Say you're going to start with Row 3 (headers in rows 1&2).

Show the Forms toolbar
click on the groupbox icon and then draw that groupbox within row 3.
Now click on the optionbutton icon on that same toolbar
Draw an optionbutton with in that groupbox
click on that option button and drag it within the groupbox (2nd button)
and do it once more for the 3rd button.

Line things up as best you can.

Rightclick on any of the 3 optionbuttons and select format control
on the control tab, type in the address of the cell that should be used as the
cell link.

Now show the drawing toolbar.
click on that arrow icon
lasso the groupbox (that'll include the 3 option buttons)

now ctrl-click and drag it to a new row.
You'll have to change the linked cell manually, though.

Repeat for as many rows as you want.

The macro tries to do all that junk for you. You may want to try it.

Stilla wrote:

Hello again Dave! Thank you for replying to my question and for waking me up
to OPTION BUTTONS!! THe link you sent was very impressive... and the
example is sort of similar to my situation. I don't know VBA though, and my
experience with macros is about a week old... So, I'm trying to do what I can
just using menus and control functions.

I have experimented with the various control functions...and it seems like I
am SOOO close, but I don't know whether I can get what I want without using
code.

The "listbox" is the closest thing... The listbox lets me make a vertical
list of entries with a vertical column of buttons. BUT..but what I'd like
to do is have this type of structu
Strong Avg Weak
question 1 button button button
question 2 button button button
question 3 button button button
question 4 button button button

Is there anyway I can do this using control toolbox/properties, without
writing code? Another limitation is that I don't want macros attached to the
form.

Thanks again..

"Dave Peterson" wrote:

How about using optionbuttons? That's the way they behave.

You may want to try this:
http://www.contextures.com/xlform01.html

Stilla wrote:

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!

--

Dave Peterson


--

Dave Peterson

  #8   Report Post  
Old December 10th 05, 03:50 AM posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Entry into check box dependent on other check box.

Hi again.. I think I already know the answer to this question, but heck, I'm
going to ask it anyway...

Is there anyway to make the pesky groupbox line invisible? Apparently, you
can't format in the forms toolbar. Arrrgh.. I thought I had this all worked
out! :-P

"Dave Peterson" wrote:

Make your rowheights slightly larger (so you can fit the option buttons and
groupbox nicely).

Say you're going to start with Row 3 (headers in rows 1&2).

Show the Forms toolbar
click on the groupbox icon and then draw that groupbox within row 3.
Now click on the optionbutton icon on that same toolbar
Draw an optionbutton with in that groupbox
click on that option button and drag it within the groupbox (2nd button)
and do it once more for the 3rd button.

Line things up as best you can.

Rightclick on any of the 3 optionbuttons and select format control
on the control tab, type in the address of the cell that should be used as the
cell link.

Now show the drawing toolbar.
click on that arrow icon
lasso the groupbox (that'll include the 3 option buttons)

now ctrl-click and drag it to a new row.
You'll have to change the linked cell manually, though.

Repeat for as many rows as you want.

The macro tries to do all that junk for you. You may want to try it.

Stilla wrote:

Hello again Dave! Thank you for replying to my question and for waking me up
to OPTION BUTTONS!! THe link you sent was very impressive... and the
example is sort of similar to my situation. I don't know VBA though, and my
experience with macros is about a week old... So, I'm trying to do what I can
just using menus and control functions.

I have experimented with the various control functions...and it seems like I
am SOOO close, but I don't know whether I can get what I want without using
code.

The "listbox" is the closest thing... The listbox lets me make a vertical
list of entries with a vertical column of buttons. BUT..but what I'd like
to do is have this type of structu
Strong Avg Weak
question 1 button button button
question 2 button button button
question 3 button button button
question 4 button button button

Is there anyway I can do this using control toolbox/properties, without
writing code? Another limitation is that I don't want macros attached to the
form.

Thanks again..

"Dave Peterson" wrote:

How about using optionbuttons? That's the way they behave.

You may want to try this:
http://www.contextures.com/xlform01.html

Stilla wrote:

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!

--

Dave Peterson


--

Dave Peterson

  #9   Report Post  
Old December 10th 05, 03:56 AM posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Here's a Trick to make groupbox border invisible.

Hi.. I figured out a little "trick" to make the groupbox invisible! I drew
a box, shaded it the color of the background, removed its border, and using
the "order" drawing command, placed it "between" the buttons and the
groupbox! Wheee! I'm back in business! If you know of a more...ehm..
elegant way, let me know.

Thanks again

"Dave Peterson" wrote:

Make your rowheights slightly larger (so you can fit the option buttons and
groupbox nicely).

Say you're going to start with Row 3 (headers in rows 1&2).

Show the Forms toolbar
click on the groupbox icon and then draw that groupbox within row 3.
Now click on the optionbutton icon on that same toolbar
Draw an optionbutton with in that groupbox
click on that option button and drag it within the groupbox (2nd button)
and do it once more for the 3rd button.

Line things up as best you can.

Rightclick on any of the 3 optionbuttons and select format control
on the control tab, type in the address of the cell that should be used as the
cell link.

Now show the drawing toolbar.
click on that arrow icon
lasso the groupbox (that'll include the 3 option buttons)

now ctrl-click and drag it to a new row.
You'll have to change the linked cell manually, though.

Repeat for as many rows as you want.

The macro tries to do all that junk for you. You may want to try it.

Stilla wrote:

Hello again Dave! Thank you for replying to my question and for waking me up
to OPTION BUTTONS!! THe link you sent was very impressive... and the
example is sort of similar to my situation. I don't know VBA though, and my
experience with macros is about a week old... So, I'm trying to do what I can
just using menus and control functions.

I have experimented with the various control functions...and it seems like I
am SOOO close, but I don't know whether I can get what I want without using
code.

The "listbox" is the closest thing... The listbox lets me make a vertical
list of entries with a vertical column of buttons. BUT..but what I'd like
to do is have this type of structu
Strong Avg Weak
question 1 button button button
question 2 button button button
question 3 button button button
question 4 button button button

Is there anyway I can do this using control toolbox/properties, without
writing code? Another limitation is that I don't want macros attached to the
form.

Thanks again..

"Dave Peterson" wrote:

How about using optionbuttons? That's the way they behave.

You may want to try this:
http://www.contextures.com/xlform01.html

Stilla wrote:

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!

--

Dave Peterson


--

Dave Peterson

  #10   Report Post  
Old December 10th 05, 04:44 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Here's a Trick to make groupbox border invisible.

You can actually hide the groupbox using a line of VBA.

Position them where you want them.
hit alt-f8 to see the VBE (where those pesky macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
activesheet.groupboxes.visible = false

To see them again, just make it true.



Stilla wrote:

Hi.. I figured out a little "trick" to make the groupbox invisible! I drew
a box, shaded it the color of the background, removed its border, and using
the "order" drawing command, placed it "between" the buttons and the
groupbox! Wheee! I'm back in business! If you know of a more...ehm..
elegant way, let me know.

Thanks again

"Dave Peterson" wrote:

Make your rowheights slightly larger (so you can fit the option buttons and
groupbox nicely).

Say you're going to start with Row 3 (headers in rows 1&2).

Show the Forms toolbar
click on the groupbox icon and then draw that groupbox within row 3.
Now click on the optionbutton icon on that same toolbar
Draw an optionbutton with in that groupbox
click on that option button and drag it within the groupbox (2nd button)
and do it once more for the 3rd button.

Line things up as best you can.

Rightclick on any of the 3 optionbuttons and select format control
on the control tab, type in the address of the cell that should be used as the
cell link.

Now show the drawing toolbar.
click on that arrow icon
lasso the groupbox (that'll include the 3 option buttons)

now ctrl-click and drag it to a new row.
You'll have to change the linked cell manually, though.

Repeat for as many rows as you want.

The macro tries to do all that junk for you. You may want to try it.

Stilla wrote:

Hello again Dave! Thank you for replying to my question and for waking me up
to OPTION BUTTONS!! THe link you sent was very impressive... and the
example is sort of similar to my situation. I don't know VBA though, and my
experience with macros is about a week old... So, I'm trying to do what I can
just using menus and control functions.

I have experimented with the various control functions...and it seems like I
am SOOO close, but I don't know whether I can get what I want without using
code.

The "listbox" is the closest thing... The listbox lets me make a vertical
list of entries with a vertical column of buttons. BUT..but what I'd like
to do is have this type of structu
Strong Avg Weak
question 1 button button button
question 2 button button button
question 3 button button button
question 4 button button button

Is there anyway I can do this using control toolbox/properties, without
writing code? Another limitation is that I don't want macros attached to the
form.

Thanks again..

"Dave Peterson" wrote:

How about using optionbuttons? That's the way they behave.

You may want to try this:
http://www.contextures.com/xlform01.html

Stilla wrote:

Hi Ron! Thanks.. this would be a good workaround.. I've now decided to have
3 columns.... strong, average, weak (against a set of skills, for example).
It will be of interest to collect each of the three types of data, for later
analyses.

I know I can accomplish this easily with validation... but I would like to
learn how to work with check boxes... they do save the user one click.

"Ron Coderre" wrote:

Why not just have one set of checkboxes that the user checks only if YES.
Unless the alternative to YES can be something other than NO.

Does that help?

***********
Regards,
Ron


"Stilla" wrote:

I'd like to have a vertical list of items and next to them I'd like to place
two vertical sets of check boxes. Let's say one set is the YES column, and
the other set is the NO column.

How do I set it up so that a user CANNOT check both YES and NO... ? So, if
someone checks YES, then changes their mind and checks NO, then the check in
he YES column would disappear and vice versa?

Does this involve complicated code?

THANKS IN ADVANCE!!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


Reply
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
How do i have a check display with any data entry in a cell jwomack Excel Discussion (Misc queries) 8 November 19th 05 01:27 AM
Can you sort with check boxes? Q Excel Discussion (Misc queries) 3 November 10th 05 09:11 PM
check boxes - copy MarkT Excel Discussion (Misc queries) 2 October 20th 05 04:33 PM
Cell value dependent on another cell entry Ajay Excel Discussion (Misc queries) 3 August 3rd 05 02:13 PM
limit text entry in a range of cells QTPRM Excel Discussion (Misc queries) 2 May 25th 05 03:52 AM


All times are GMT +1. The time now is 07:39 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017