I would like to allow a user to select data with 3 options. I've used
checkboxes when the option is just on or off (incomplete or
complete). Sometimes the data does not apply, so I'd like a
"checkbox" which allows 3 conditions: N/A, on (complete), and off
(pending/incomplete).

I'm already using VBA macros to implement changes based on the
checkboxes. It would be nice to tie code options based on a 3 (or
more) position switch control. Is there such a thing?

Consider a userform with radio buttons
--
Gary''s Student - gsnu200813


"jafsonic" wrote:

I would like to allow a user to select data with 3 options. I've used
checkboxes when the option is just on or off (incomplete or
complete). Sometimes the data does not apply, so I'd like a
"checkbox" which allows 3 conditions: N/A, on (complete), and off
(pending/incomplete).

I'm already using VBA macros to implement changes based on the
checkboxes. It would be nice to tie code options based on a 3 (or
more) position switch control. Is there such a thing?

On Nov 12, 3:16*pm, Gary''s Student
wrote:
Consider a userform with radio buttons
--
Gary''s Student - gsnu200813



"jafsonic" wrote:
I would like to allow a user to select data with 3 options. *I've used
checkboxes when the option is just on or off (incomplete or
complete). *Sometimes the data does not apply, so I'd like a
"checkbox" which allows 3 conditions: *N/A, on (complete), and off
(pending/incomplete).

I'm already using VBA macros to implement changes based on the
checkboxes. *It would be nice to tie code options based on a 3 (or
more) position switch control. *Is there such a thing?- Hide quoted text -

- Show quoted text -

Thanks. I thought about a userform option and even radio buttons on
the sheet, but wasn't going that way since this a relatively simple
status page intended for real-time updating in front of an audience
who probably arent' going to want to watch you navigate forms. It may
still be an option though.

Set the TripleState property to True
--
Jim Cone
Portland, Oregon USA



"jafsonic"
wrote in message
I would like to allow a user to select data with 3 options. I've used
checkboxes when the option is just on or off (incomplete or
complete). Sometimes the data does not apply, so I'd like a
"checkbox" which allows 3 conditions: N/A, on (complete), and off
(pending/incomplete).

I'm already using VBA macros to implement changes based on the
checkboxes. It would be nice to tie code options based on a 3 (or
more) position switch control. Is there such a thing?