As far as I understand it they do the same thing, but while is triggered every time selection is changed on a single worksheet, Workbook_SheetSelectionChange is triggered every time selection is changed in any worksheet in the workbook.
Are there any other differences between these events?
I ha...
You are confusing two things. When you have a multi-selection ListBox, users will use the following code because .SelectedItems collection has to be variant:
Dim varItm as Variant
For Each varItm in myListBox.SelectedItems
'Do Something
Next varItm
However, there is further documentation ...
As far as I understand it they do the same thing, but while is triggered every time selection is changed on a single worksheet, Workbook_SheetSelectionChange is triggered every time selection is changed in any worksheet in the workbook.
Are there any other differences between these events?
I ha...
You are confusing two things. When you have a multi-selection ListBox, users will use the following code because .SelectedItems collection has to be variant:
Dim varItm as Variant
For Each varItm in myListBox.SelectedItems
'Do Something
Next varItm
However, there is further documentation ...
In Excel VBA, how do I offset/resize the left column of a range by 1 less?
For instance I start with B1:D10 and I need to end up with C1:D10.
VBA Rubberducking
VBA Rubberducking