{"path":"2259311","ref":"et_turntable.md","title":"157-呵呵，失败的抽奖！","content":"> Mon Apr 26 2021 14:57:41 GMT+0800 (GMT+08:00)\n\n![](https:\/\/img.kancloud.cn\/b9\/71\/b971b377bfdbf8cde51a0979ef8aa3a2_789x400.png)\n\n```js\nfunction resultRange(fontColor, colorIndex) {\n\n    Range(\"B2\").Font.Color = fontColor\/\/49407\n    Range(\"B2\").Interior.ColorIndex = colorIndex\/\/1\n}\nfunction turntable() {\n    resultRange(-4142, -4142)\n    Range(\"B2\").Value2 = \"\"\n    let tableItems = [\n        \"A1\",\n        \"B1\",\n        \"C1\",\n        \"D1\",\n        \"D2\",\n        \"D3\",\n        \"D4\",\n        \"C4\",\n        \"B4\",\n        \"A4\",\n        \"A3\",\n        \"A2\"\n    ];\n    \/\/ 随机圈数\n    let counts = WorksheetFunction.RandBetween(0, 2)\n    \/\/ 随机中奖者\n    let lg = WorksheetFunction.RandBetween(0, tableItems.length - 1)\n\n    let secondTimes = () => { return WorksheetFunction.RandBetween(1, 5) }\n\n    for (let i = 0; i <= counts; i++) {\n        let lastC\n        if (i == counts) {\n            lastC = lg\n        } else {\n            lastC = tableItems.length - 1 \/\/\n        }\n        for (let x = 0; x <= lastC; x++) {\n            let rngName = tableItems[x]\n            let trange = Range(rngName)\n            let trange_color = trange.Interior.ColorIndex\n            trange.Interior.ColorIndex = 3\n            trange.Select()\n            let now = new Date()\n            let seconds = now.getTime()\n            now.setTime(seconds + 300)\n            Application.Wait(now.toLocaleString())\n            trange.Interior.ColorIndex = trange_color\n            if (x == lastC && i == counts) {\n                let p = resultRange(49407, 1)\n                let winner = tableItems[lg];\/\/中奖单元格\n                Range(\"B2\").Formula = \"=\" + winner\n            }\n        }\n    }\n}\n```\n\n> 看着改吧，糟糕极了。\n"}