Greg,
How do you put your chart on the userform ?
If the data behind a chart changes, then the Worksheet_Change event fires.
This can be update trigger.
NickHK
"Greg" wrote in message
oups.com...
NickHK napisal(a):
Greg,
You still need to activate the code from some event.
What is changing that you need to refresh ?
I don't understand the connection between your userForm and "the
currently
selected shape".
I need to refresh userForm because chart or series on chart is
changing.
For example, I need to show size "new" chart but I don't want to press
any button.
ModelessForm.zip (http://www.oaltd.co.uk/Excel/SBXLPage.asp) is almost
what I want to achieve but working with cells, not chart.
Greg