ufapplications.blogg.se

You can download a spreadsheet with the example here. In the first example we make only one cell blink in the other example it can be several cells in a range. In the examples below we make use of the Worksheet_Change proceduren that executes automatically, when a cell or a range is changed in the sheet, and this also happens if the colour of a cell changes. It is not unlike conditional formatting, but conditional formatting cannot make cells blink - at least not in the old Excel versions I use.Įvery sheet in an Excel spreadsheet has a VBA code sheet, where you can put some standard procedures that are called automatically, if certain events happen on the sheet. The examples also show, how VBA's OnTime function can be used to "plan" execution of a procedure at a given time. On this page I show, how a macro can make one or more cells blink automatically, if the cell content doesn't meet a condition, and how the blink stops, if the cell value is changed to something okay. Blinking cells in Excel and the OnTime function