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

[DocAElstein]

_... from last post

_____ 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

Some Immediate window results
? Range("AM15").font.ThemeColor
7
? Range("AM15").font.TintAndShade
0
? Range("AM15").font.Color
10855845
? Range("AM15").font.Colorindex
48
? Range("AM16").font.tintandshade
0
? Range("AM16").font.Bold
Falsch
? Range("AM16").font.Color
6751362
? Range("AM16").font.Colorindex
13
? Range("AM16").font.Bold
Falsch
? Range("AT19").Font.Tintandshade
0
? Range("AT19").Font.Color
0
? Range("AT19").Font.colorindex
-4105
? Range("AT19").Font.Bold
Falsch