✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
The exciting thing about Excel, in combination with the VBA language, is that we can do almost everything we can think of, from the simplest to the most complex. In simple things, however, we can learn many things about objects in Excel and how to interact with them.
First of all, events in Excel
Events trigger when an action occurs in Excel, whether it is activating sheets, saving, printing, right clicking, etc. In this Post we will focus on the SelectionChange event, which is triggered when we select cells in a spreadsheet and / or when we change a selection on a sheet.
Highlight row and selected cell
In the example file we have a procedure that highlights the row where the active cell is selected, as well as highlighting the selected cell, as shown in Figure 1.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
26 авг 2024