VBA+API refresh userForm

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Using Show with vbModeless parameter I can change chart which I try to
modify.
How can I refresh my userForm to show parameters current chart (e.i.
size). Of course, it is possible to use button which loads up the
settings for the currently selected shape and displays them. But I need
to do it automatically, without button. Maybe API can help to do it but
I didn't find out any examples.
Can you help me?

Greg
 
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".

NickHK
 
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".
Click to expand...

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
 
Hello Greg,

At the appropriate point in your code add this line. Change USerForm1
to the name of your form.

UserForm1.Repaint

You may see a little flicker when it refreshes the form.

Sincerely,
Leith Ross
 
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
 
Back
Top