Скачать или смотреть Highlight cells automatically using VBA

In this video, we use a Workbook Event (mouse selection of cells and ranges in a spreadsheet) to automatically change the fill color and border color of all cells in a selection.

VBA Excel ColorIndex Property link: http://access-excel.tips/excel-vba-co...

More info about VB passing mechanisms ByRef and ByVal:
https://docs.microsoft.com/en-us/dotn...

Be sure to like, subscribe, and click the notification bell.

Please comment below and let me know what you think about the video or if you have anything to add.

TheAccidentalExcelist.com is currently under redesign and reconstruction. Look for it to return soon.

In the meantime, check me out at toddbrannon.com.

Thanks for watching and have a great day!