3-position switch control
 

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?

3-position switch control
 

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?

3-position switch control
 

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.

3-position switch control
 

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?