1 checkbox at a time.

[jcmckeon]

Hello All,

I want the user to select only 1 checkbox at a time with the others locked. Clicking the box loads corresponding information in the table. So clicking the checkbox next to Internal/Customer should bring up that info in the cells. But if you select 2 click boxes the information is messed up.
Look at the attached. I tried some vb but not successful. The easiest solution, the better. If we can do without vbs, great!

Thank you in advance. Looking forward to replies. Be well in the meantime. Jill

NOTE: THE CHECKBOXES DON'T SHOW USING MINI TABLE - THEY'RE FORM CONTROLS NOT ACTIVEX I DON'T HOW WE DO IT JUST SO IT CAN BE DONE.

MA-F9 A - 8D For CAPA (blank) JCMV.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1		8D Problem Solving Report
2											CAPA Number
3		D0 Problem Solving Summary Type
4		Select only one:		Internal / Customer		FALSE	Customer		FALSE	Supplier		FALSE
5		Header Information
6		select summary type - D0				select summary type - D0
7		select summary type - D0				select summary type - D0
8		select summary type - D0				select summary type - D0
9		select summary type - D0				select summary type - D0
10		select summary type - D0				select summary type - D0
11		select summary type - D0				select summary type - D0
12		D1 Problem Solving Team
13		Team Leader
14		Team:
15		D2 Problem Description (Description of Nonconformance)
16
17
18
19
20
21		D3 Containment: Consider - Supplier Inventory, Supplier Work in Progress, External Processing, In Transit
22
23
24
25
26
27		Completed By:								Date:
28		D4 Root Cause Analysis- 5 Why required
29
30
31
32
33
34
35		Completed By:								Date:
36		D5 Corrective Action
37
38
39
40
41
42		Completed By:								Date:
43		D6 Implementation and Verification of Corrective Actions
44
45
46
47
48
49		Completed By:								Date:
50		D7 Identify and Implement Preventive Actions
51
52
53
54
55
56
57		Completed By:								Date:
58		8D Approved By:								Date:
59		D8 Team Recognition
8D Reports

Cell Formulas
Range	Formula
B6	B6	=IF($F$4=TRUE,"Defect Type",IF($I$4=TRUE,"Defect Type:",IF($L$4=TRUE,"Defect Type","select summary type - D0")))
B7	B7	=IF($F$4=TRUE,"Source:",IF($I$4=TRUE,"Customer Name:",IF($L$4=TRUE,"Supplier Name:","select summary type - D0")))
B8	B8	=IF($F$4=TRUE,"Process:",IF($I$4=TRUE,"Customer Return #:",IF($L$4=TRUE,"Supplier Contact Name:","select summary type - D0")))
B9	B9	=IF($F$4=TRUE,"Process Owner:",IF($I$4=TRUE,"Customer PO #:",IF($L$4=TRUE,"Supplier PO #:","select summary type - D0")))
B10	B10	=IF($F$4=TRUE,"Operation #:",IF($I$4=TRUE,"Buyer Name:",IF($L$4=TRUE,"Job #","select summary type - D0")))
B11	B11	=IF($F$4=TRUE,"Enter Additional Info:",IF($I$4=TRUE,"Enter Additional Info:",IF($L$4=TRUE,"Lot Quantity:","select summary type - D0")))
F6	F6	=IF($F$4=TRUE,"Job #:",IF($I$4=TRUE,"Job #:",IF($L$4=TRUE,"Quantity Rejected","select summary type - D0")))
F7	F7	=IF($F$4=TRUE,"Quantity Rejected:",IF($I$4=TRUE,"Quantity Rejected:",IF($L$4=TRUE,"Part Number(s):","select summary type - D0")))
F8	F8	=IF($F$4=TRUE,"Part Number(s):",IF($I$4=TRUE,"Quantity Reworked:",IF($L$4=TRUE,"Part Revision #:","select summary type - D0")))
F9	F9	=IF($F$4=TRUE,"Part Revision #:",IF($I$4=TRUE,"Part Number(s):",IF($L$4=TRUE,"Part Serial #","select summary type - D0")))
F10	F10	=IF($F$4=TRUE,"Part Serial #:",IF($I$4=TRUE,"Part Revision #:",IF($L$4=TRUE,"8D Due Date:","select summary type - D0")))
F11	F11	=IF($F$4=TRUE,"DMR #:",IF($I$4=TRUE,"Part Serial #:",IF($L$4=TRUE,"DMR #:","select summary type - D0")))

 

[FormR]

Hi, I've not fully digested your post, but can't you use option buttons rather than check boxes?

 

[jcmckeon]

Hi, I've not fully digested your post, but can't you use option buttons rather than check boxes?

I’ll do whatever. Do option buttons use key off true false? I’d like to use the formulas I wrote but I’ll take any guidance. Thanks for answering

 

[FormR]

Do option buttons use key off true false?

Hi, I'm guessing that you've already discovered that the control tab of the format control menu is identical to that of checkboxes?

 

[jcmckeon]

Hi, I'm guessing that you've already discovered that the control tab of the format control menu is identical to that of checkboxes?

 

[jcmckeon]

I got it done. Thank you for the information. Very much appreciated!