Double click at the sheet you want to use the code in the Project Explore pane, and paste below code to the Module script. Press Alt + F11 keys to open Microsoft Visual Basic for Applications window.Ģ. To change the filled color of active cell is a good choice to make it outstanding, but there is no built-in function to help you except macro code.ġ. Outstanding active cell with Kutools for Excel Change border color of active cell with VBA In this article, I will give you some tricks on changing border of the active cells for making it differ from others in Excel.Ĭhange border color of active cell with VBA
But in some times, you want to change the border color of the active cell for more outstanding from others. In Excel, the border color of active cell or range are different from others as below screenshot shown.