Excel VBA macro runs after an object has been moved -
i know how assign macro cell , launch when has changed. i know how assign macro 'button' , launch when clicked. i know how assign macro worksheet , launch when cell has changed.
but ..... have text box in chart , wish have macro launch after text box has been moved new location. currently, click on 'button' after move text box , works well. eliminate final step in order avoid problem if user fails click button.
if there no built-in event associated worksheet property or characteristic wish monitor, can utilize application.ontime macro monitor item.
for illustration topleftcell.address of shape can monitored phone call call , action taken if property changes.
some info see ontime
excel vba automation
No comments:
Post a Comment