Forum Discussion
Solved
Can we somehow use this unlisted selection change event?
Hi! Can we somehow in VBA use event which updates this values: It's some advanced version of SelectionChange event which isn't listed in VBA editor. :) Thanks.
Oh I see!
I dont think theres an event for this but you could probably get there with a combination something like..
Start a timer on the mouse down trigger, pull the status bar total every x milliseconds until it meets the value you want...?
Hi Nick and Tiara,
It seems that I didn't explain my problem good enough. :)
I don't want update or add something to status bar. We have SelectionChange and SheetSelectionChange events which triggers after I select some range and release mouse button or keyboard key. I know how to use them and their limitation.
I want event which triggers during range selecting, when number of selected cells is changing and mouse button is still pressed. If that event exists, it's probably used for updating values I yellowed on print screen in first post. If you press mouse button and start moving mouse you'll select more and more cells. After every new cell selected, Excel updates count/sum/average... values in status bar. If I try to do same with SelectionChange and SheetSelectionChange events, values will only be updated after I release mouse button.
I hope that my description is now more understandable. :)
Thanks for help. :)
It seems that I didn't explain my problem good enough. :)
I don't want update or add something to status bar. We have SelectionChange and SheetSelectionChange events which triggers after I select some range and release mouse button or keyboard key. I know how to use them and their limitation.
I want event which triggers during range selecting, when number of selected cells is changing and mouse button is still pressed. If that event exists, it's probably used for updating values I yellowed on print screen in first post. If you press mouse button and start moving mouse you'll select more and more cells. After every new cell selected, Excel updates count/sum/average... values in status bar. If I try to do same with SelectionChange and SheetSelectionChange events, values will only be updated after I release mouse button.
I hope that my description is now more understandable. :)
Thanks for help. :)
Oh I see!
I dont think theres an event for this but you could probably get there with a combination something like..
Start a timer on the mouse down trigger, pull the status bar total every x milliseconds until it meets the value you want...?
- Thanks. I totally forgout about timer usage. :)
You're welcome :smileyvery-happy:
Best of luck in the main comp:smileyhappy: