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

[DocAElstein]

First 3 section output after running Sub SpltTests() from last post ( http://www.excelfox.com/forum/showth...0881#post10881 , https://tinyurl.com/yd95w5v2 )

_____ Workbook: Sample.xlsm ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H
1	S1	S2		S1	S2		S1	S2
2	1	1377		41	1417		81	1457
3	2	1378		42	1418		82	1458
4	3	1379		43	1419		83	1459
5	4	1380		44	1420		84	1460
6	5	1381		45	1421		85	1461
7	6	1382		46	1422		86	1462
8	7	1383		47	1423		87	1463
9	8	1384		48	1424		88	1464
10	9	1385		49	1425		89	1465
11	10	1386		50	1426		90	1466
12	11	1387		51	1427		91	1467
13	12	1388		52	1428		92	1468
14	13	1389		53	1429		93	1469
15	14	1390		54	1430		94	1470
16	15	1391		55	1431		95	1471
17	16	1392		56	1432		96	1472
18	17	1393		57	1433		97	1473
19	18	1394		58	1434		98	1474
20	19	1395		59	1435		99	1475
21	20	1396		60	1436		100	1476
22	21	1397		61	1437		101	1477
23	22	1398		62	1438		102	1478
24	23	1399		63	1439		103	1479
25	24	1400		64	1440		104	1480
26	25	1401		65	1441		105	1481
27	26	1402		66	1442		106	1482
28	27	1403		67	1443		107	1483
29	28	1404		68	1444		108	1484
30	29	1405		69	1445		109	1485
31	30	1406		70	1446		110	1486
32	31	1407		71	1447		111	1487
33	32	1408		72	1448		112	1488
34	33	1409		73	1449		113	1489
35	34	1410		74	1450		114	1490
36	35	1411		75	1451		115	1491
37	36	1412		76	1452		116	1492
38	37	1413		77	1453		117	1493
39	38	1414		78	1454		118	1494
40	39	1415		79	1455		119	1495
41	40	1416		80	1456		120	1496
42	S1	S2		S1	S2		S1	S2
43	121	1497		161	1537		201	1577

Worksheet: Result