Appendix Thread. ( Codes for other Threads, etc.) Event Coding Drpdown Data validation

[DocAElstein]

In support of this Thread answer

List table supplied by OP in uploade file

_____ Workbook: Book1.xlsx ( Using Excel 2007 32 bit )

Row\Col	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB
15	(Select Here)
16	Nuclear Family							(Remark if any)
17	Joint Family							(Remark if any)
18	Single-Parent Family							(Select Reason)
19								Expired
20								Divorced
21								Break-Up
22								Abandonment
23								Enter Reason Manually
24	Joint Family							(Please Specify the Case)

Worksheet: Sheet1


I am not sure why get those strange black areas , so I did a find on [td=bgcolor:#000000] replacing withnothing


_____ Workbook: Book1.xlsx ( Using Excel 2007 32 bit )

Row\Col	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB
15
16
17
18
19
20
21
22
23
24

Worksheet: Sheet1

So I did a find on [td=bgcolor:#000000] replacing with [td]

_....see next post