Back on the sheet you will see the effect of this method changed. Then in the developer tab, select visual Basic and click on the sheet you want to modify that method, and paste to it. ![]() If you don't know how to enter VBA editor, if you don't see developer tab, press the Office Button and Excel Options, in Popular, the third row of checkboxes "show developer tab", just check it. The VBA MACRO uses the Sheet's internal methods for event detection, the event it self is "selection change", this method is triggered each time you change from cell to cell, not the color change but the cell selection change (the actual cell). ![]() Nope, You don't need to add a module, you just add to the sheet's code page.Įxcel Sheets allow the programmers to customize their objects methods Re: How do i auto fill cell color based on other cells' color?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |