hello
in vba excel you have events generated like worksheet_xxxx
that become executed when they appears.
only i am searching for the event that is triggered when you
paste a range of cells.
thanks in advance
Printable View
hello
in vba excel you have events generated like worksheet_xxxx
that become executed when they appears.
only i am searching for the event that is triggered when you
paste a range of cells.
thanks in advance
There is no real event for the pasting of data into an Excel sheet/cell.
What you could use is the Sheet_SelectionChange(ByVal Target As Range) event. It fires when the focus changes from
one cell to another.
and how do i know which cells are selected.
let's say i want to show it in a messagebox.
for example:
i made a selection A1:B3.
how can make the string "A1:B3" appear in a messagebox???
The passed in parameter - Target in the arguments list of the procedures signature: ByVal Target As Range.