Wednesday 15 July 2015

Excel VBA macro runs after an object has been moved -



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